Create Table Question

How would you setup a sample Create Table statement with having to specify a constraint name for a Primary Key in the table.

Would it go something like this:

Create Table EMPLOYEES
(

   FName	VARCHAR(15)	NOT NULL,
   MINIT	CHAR, 
   LName	VARCHAR(15)	NOT NULL,
   SSN		CHAR(9)		NOT NULL,
   BDATE	CHAR(25),
   Address	VARCHAR(30),
   Sex		CHAR,
   Salary	DECIMAL(10,2),	
   SUPERSSN	CHAR(9),
   DNO		INT,
  Primary Key(SSN) Constraint PK_SSN,		<------ look here ------

Thanks in advance

Victor Received on Wed Jul 09 2003 - 22:23:44 CEST