How to add unique key in a table

Jak
Jak
Member
908 Points
132 Posts

How to add unique key in a table?

Views: 8987
Total Answered: 1
Total Marked As Answer: 0
Posted On: 30-Jan-2015 22:43

Share:   fb twitter linkedin
Answers
Rahul Maurya
Rahul M...
Teacher
4826 Points
23 Posts
         

Use following alter command:

ALTER TABLE <TableName> ADD CONSTRAINTS <ConstraintName> UNIQUE(<FieldName>)

Posted On: 30-Jan-2015 22:47
 Log In to Chat