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
- 15180 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
What is a relationship and what are they?
How do you use collections in procedure to return the resultset?
What are the most important ddl statements in sql?
What are the types of views in sql?
Can you selectively load only those records that you need? : aql loader
Can we create table inside stored procedure?
Can we join two tables without common column?
What is the clause we need to add in function body to return variable?
What are user defined functions?
What is the use of non clustered index?
What is group by in sql?
What is sqlservr exe?
Why truncate is faster than delete?
What is not in sql?
What are the different dcl commands in sql?
