Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?
1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
- 7 Answers
- 14929 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sdp
A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Is sql considered coding?
what is a unique key ? : Sql dba
What is a constraint? Tell me about its various levels.
What if we write return in procedure?
What is rowtype?
Can we use insert statement in function?
What's the difference between a primary key and a clustered index?
How delete all data from table in sql?
Where not exists in sql?
What is localdb mssqllocaldb?
What are variables in pl sql?
What are different functions in sql?
What is difference between inner join and self join?
What is difference between primary and secondary key?
What is raid? How does it help storage of databases?
