Answer: We have to write
Unique keyword after Datatype as:-
Syntax:-
Create Table Table_Name(Col1 DataType Unique(ID),Col2 DataType);
For Example:-
Create Table Employee_Master(Emp_Name varchar(20),PAN_Number varchar(10) Unique,Address Varchar(100),Phone_Number int);
Asked In: Many Interviews |
Alert Moderator