clif@6sigma.uucp (Clif McLaurin) (03/01/91)
I need some information on the differences between the ANSI and DB2 DDL's. Specifically, For DB2: 1. Primary keys: Can you name the primary keys in the CREATE TABLE statement? Do they have to be NOT NULL or UNIQUE? 2. Foreign keys: Can you name the foreign keys in the CREATE TABLE statement? 3. NOT NULL : How and where do you define this for a column? 4. UNIQUE : How and where do you define this for a column? 5. Where and when are the ALTER TABLE statements used? If there is interested, I will post a review. Please mail to the address below! I appreciate the help. Thanks in advance. -- Clif McLaurin Six Sigma CASE, Inc. 13456 SE 27, Suite 210 clif@6sigma.UUCP (206) 643-6911 Bellevue, WA 98005-4211