Database Reference
In-Depth Information
Figure 18.4
CREATE TABLE
Syntax for a
Relational Table.
, SALE_PRICE FLOAT DEFAULT 0
, SALE_DATE DATE DEFAULT SYSDATE
, SALE_QTY NUMBER DEFAULT 0
, SHIPPING_COST FLOAT DEFAULT 0
, CONSTRAINT
XPKSALES PRIMARY KEY (SALES_ID)
, CONSTRAINT
FKSALES_1 FOREIGN KEY (RETAILER_ID)
REFERENCES RETAILER
, CONSTRAINT
FKSALES_2 FOREIGN KEY (CONTINENT_ID)
REFERENCES CONTINENT
, CONSTRAINT
FKSALES_3 FOREIGN KEY (COUNTRY_ID)
REFERENCES COUNTRY);
CREATE INDEX XFK_SALES_1 ON SALES (RETAILER_ID);
CREATE INDEX XFK_SALES_2 ON SALES (CONTINENT_ID);
CREATE INDEX XFK_SALES_3 ON SALES (COUNTRY_ID);
18.3.2
Creating Object Tables
Creating an object table has a slightly different syntax from that of a rela-
tional table. Figure 18.5 shows the CREATE TABLE command syntax,
highlighting aspects particular to object tables.
