Create Table Question

[Victor M.]

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

[andrewst]

Originally posted by Victor M .

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

...
DNO INT,
Constraint PK_SSN Primary Key(SSN) ,
...

(BTW the manuals are helpful for finding out correct syntax!)

--
Posted via http://dbforums.com

[michael ngong]

Victor M. <eh***@hotmail.com> wrote in message news:<MP************************@nntp.slnt.phub.ne t.cable.rogers.com>...

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

The line with the primary key should read

constraint pk_ssn primary key(ssn)


Michael Tubuo Ngong