Primary and Unique keyword is used to create primary key and unique key on columns. CREATE TABLE EMPLOYEE_MASTER
(
EMPLOYEE_ID int PRIMARY KEY, --Define primary key
EMPLOYEE_NAME varchar (50) NOT NULL,
CONTACT_NO int UNIQUE, --Define unique key
PAN_NO varchar(10) NULL
)