How to assign primary key to any column in the table?

 Posted by vishalneeraj-24503 on 3/5/2014 | Category: Sql Server Interview questions | Views: 1472 | Points: 40
Answer:

Suppose,i want to create table called project_master and to assign a primary key to ID column,just give primary key after datatype as

create table Project_Master

(
project_id int primary key,
project_name varchar(50)
)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response