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
- 15429 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
1) primary key don't allow null values but unique const
allow null values
2)we can declare primary key as multiple column. but table
should have one primary key
3)we can declare unique as multiple column. but table should
have one unique key
4) and 5)
in table we can create multiple column of primary key and
multiple column of unique. but only the restriction is in
table should have one primary key and one unique key .. if
it is neccessary.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Which nosql database is best?
How to add new employee details in an employee_details table with the following details
Why do we use sqlite?
Explain the purpose of %type and %rowtype data types with the example?
What is difference between procedure and trigger?
How do you optimize a stored procedure in sql?
How many types of relationship are there?
Is pl sql different from sql?
What is the need of merge statement?
When is a declare statement required?
Why stored procedures are faster than query?
What are the possible values for the boolean data field?
What does select * from mean in sql?
What is cold data?
What is sorting in sql?
