How to assign check constraint a Name for multiple columns in Sql Server?

 Posted by vishalneeraj-24503 on 9/1/2014 | Category: Sql Server Interview questions | Views: 206 | Points: 40
Answer:

Refer below script:-
Create Table Employee_Master

(
Employee_Id int not null Constraint ck_employee Check([PAN_Number] Is Not Null),
First_Name varchar(100) not null,
Middle_Name varchar(100),
Last_Name varchar(100) not null,
Employee_Name varchar(100) not null,
PAN_Number varchar(10) not null,
LDAP varchar(10) not null
)
)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response