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

@@ Line 21: / Line 21: @@
   ,b VARCHAR(10)
   )
 </source>
 <div class="ecomm e-access" style="display: none">

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.