DB2 V9.5 Cookbook SQL DDL.docVIP

DB2 V9.5 Cookbook SQL DDL ----------------------------------------------------------- --- --- --- FILE: HTM_DDL.HTML --- --- AUTHOR: G.BIRCHALL --- --- DATE: 19/NOV/2007 --- --- --- --- INTRODUCTION: DB2 comes with a module that --- --- creates and populates the SAMPLE database. --- --- --- --- A simplified version of the DDL and DML --- --- that DB2 uses is provided below. The code --- --- is complete - except for the following: --- --- --- --- - No RI rules created. --- --- - No triggers created. --- --- - No views created. --- --- - Only 250 rows (out of 10,000) inserted --- --- into the EMPMDC table. --- --- - No BLOB, CLOB, DBCLOB, or XML column --- --- values inserted. --- --- --- --- NOTE: Ive used a table qualifier of FRED. --- --- Change or remove as you wish. --- --- --- ----------------------------------------------------------- DROP ALIAS FRED.DEPT; DROP ALIAS FRED.EMP; DROP ALIAS FRED.EMPACT; DROP ALIAS FRED.EMP_ACT; DROP ALIAS FRED.PROJ; DROP TABLE FRED.ACT; DROP TABLE FRED.CATALOG; DROP TABLE FRED.CL_SCHED; DROP TABLE FRED.CUSTOMER; DROP TABLE FRED.DATA_FILE_NAMES; DROP TABLE FRED.DEPARTMENT; DROP TABLE FRED.EMPLOYEE; DROP TABLE FRED.EMPMDC; DROP TABLE FRED.EMPPROJACT; DROP TABLE FRED.EMP_PHOTO; DROP TABLE FRED.EMP_RESUME; DROP TABLE FRED.INVENTORY; DROP TABLE FRED.IN_TRAY; DROP TABLE FRED.