Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!rpi!dali.cs.montana.edu!milton!sumax!polari!6sceng!6sigma!6sigma.uucp
From: clif@6sigma.uucp (Clif McLaurin)
Newsgroups: comp.databases
Subject: Differences between ANSI and DB2 SQL DDL.
Message-ID: <413@6sigma.UUCP>
Date: 28 Feb 91 18:08:51 GMT
Sender: clif@6sigma.UUCP
Distribution: na
Organization: Six Sigma CASE, Inc.
Lines: 25

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