DB2 Everyplace Characteristics
CREATE TABLE
with following datatypes
INTEGER
SMALLINT
DECIMAL (Big)
CHARACTER(Smallint)
VARCHAR(Smallint)
BLOB(Smallint)
DATE
TIME TIMESTAMP
and options
PRIMARY KEY with more than one column referential constraints
CHECK constraints
CREATE TABLE |
|
|
create table ORDERS |
|
|
|
| |
|
| |
(CUSTNO CHAR(6) | NOT NULL, | |
ENTRY TIMESTAMP | NOT NULL DEFAULT Current Timestamp, | |
ITEM CHAR(15) ,
PRICE DECIMAL(9,2),
Check (Price < 100),
PRIMARY KEY (CUSTNO,ENTRY))
Page
