How to add unique key in a table

Jak
Jak
Member
858 Points
132 Posts

How to add unique key in a table?

Views: 8982
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
4822 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