Home | Previous Page | Next Page   Appendix B. Demonstration SQL > SQL Files for the Relational Database Model >

c_manuf.sql

The following command file creates the manufact table:

CREATE TABLE manufact
   (
   manu_code               CHAR(3),
   manu_name               CHAR(15),
   lead_time               INTERVAL DAY(3) TO DAY,
   PRIMARY KEY (manu_code)
   );
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]