|
The PRIMARY KEY clause has the following form:
[CONSTRAINT c_name]
PRIMARY KEY [CLUSTERED | NONCLUSTERED] (col_name1 [{,col_name2} ...])
11>
12> CREATE TABLE employee (emp_no INTEGER NOT NULL,
13> emp_fname CHAR(20) NOT NULL,
14> emp_lname CHAR(20) NOT NULL,
15> dept_no CHAR(4) NULL,
16> CONSTRAINT prim_empl PRIMARY KEY (emp_no))
17>
18> drop table employee;
19> GO
1>
|