H2 DDL Operations

From NovaOrdis Knowledge Base
Revision as of 17:59, 25 September 2017 by Ovidiu (talk | contribs) (→‎Create Table)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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>;