H2 DDL Operations: Difference between revisions

From NovaOrdis Knowledge Base
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>;