IBM 7.2.1 Uživatelský manuál stáhnout pdf (Strana 13)

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 25-26

1 2 ... 8 9 10 11 12 13 14 15 16 17 18

Žádné komentáře

IBM 7.2.1 Uživatelský manuál Strana 13