Re: Create Table Question

In article
<MPG.1976438ceaff88bb989681_at_nntp.slnt.phub.net.cable.rogers.com>, eh936_at_hotmail.com says...
> 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 ------
> Foreign Key(SUPERSSN) REFERENCES EMPLOYEES(SSN),
> Foreign Key(DNO) REFERENCES DEPARTMENT(DNUMBER)
> );
>
> Thanks in advance
>
> Victor
>

Thanks everybody all feedback was appreciated. Received on Thu Jul 10 2003 - 20:26:33 CEST