H2 DDL Operations: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * H2 =Create Table= =Update Table Definition= =Delete Table=") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
=Create Table= | =Create Table= | ||
CREATE TABLE ''<table-name>''(''<primary-key-column-name>'' INT PRIMARY KEY, ''<column-1-name>'' VARCHAR(255)); | |||
CREATE TABLE TEST (ID INT PRIMARY KEY, NAME VARCHAR(255)); | |||
=Update Table Definition= | =Update Table Definition= | ||
=Delete Table= | =Delete Table= | ||
DROP TABLE IF EXISTS ''<table-name>''; | |||
Latest revision as of 17:59, 25 September 2017
Internal
Create Table
CREATE TABLE <table-name>(<primary-key-column-name> INT PRIMARY KEY, <column-1-name> VARCHAR(255));
CREATE TABLE TEST (ID INT PRIMARY KEY, NAME VARCHAR(255));
Update Table Definition
Delete Table
DROP TABLE IF EXISTS <table-name>;