Mega Code Archive
PRIMARY KEY column
4> CREATE TABLE employee(
5> emp_no INTEGER NOT NULL CONSTRAINT prim_empl PRIMARY KEY,
6> emp_fname CHAR(20) NOT NULL,
7> emp_lname CHAR(20) NOT NULL,
8> dept_no CHAR(4) NULL)
9> GO
1>
2> drop table employee;
3> GO
1>