Category : Files from Magazines
Archive   : DBMS0291.ZIP
Filename : GERRIT1.FEB

 
Output of file : GERRIT1.FEB contained in archive : DBMS0291.ZIP


Listing 1--CREATE TABLE commands

CREATE TABLE customer (
c# CHAR(5),
name CHAR(12),
city CHAR(15));

CREATE TABLE part (
p# CHAR(5),
pname CHAR(10),
color CHAR(10),
wt NUMERIC,
price NUMERIC);

CREATE TABLE invoice (
i# CHAR(5),
c# CHAR(5),
idate DATE);