Difference between revisions of "CREATE a new table"

Revision as of 14:50, 12 July 2012

CREATE a new table

schema:gisq

The following are examples of field types:

DROP TABLE t_test

CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR2(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR(10)
 )

CREATE a new table

DROP a table

@@ Line 31: / Line 31: @@
 </div>
 </div>
-{{SELECT Ref}}
+{{CREATE and DROP ref}}

MEMO	Allows up to 65535 characters
CURRENCY	Suitable for money.

CLOB	Allows large character fields.
NUMBER(10,2)	Up to 10 digits before the point, 2 after.

TEXT	Allows up to 65535 characters
DECIMAL(10,2)	Up to 10 digits before the point, 2 after.