DefinIng Primary key and Unique key On Tables

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 634
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
)

Comments or Responses

Login to post response