Constraints MSSQL

  1. Home
  2. MSSQL
  3. Constraints
  4. Define Primary key in table creation command
20>
21> CREATE TABLE employee (emp_no     INTEGER  NOT NULL,
22>                        emp_fname  CHAR(20) NOT NULL,
23>                        emp_lname  CHAR(20) NOT NULL,
24>                        dept_no    CHAR(4)  NULL,
25>                        CONSTRAINT prim_empl PRIMARY KEY (emp_no))
26> GO
1>
2> drop table employee
3> GO
1>
2> -- 
3>