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
- 15435 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
A table can have compite primarykey but only one unique
constraint
| Is This Answer Correct ? | 0 Yes | 15 No |
Post New Answer View All Answers
What is constant in pl sql?
Can we insert data into view?
How do I write a sql query in pgadmin 4?
What is a natural join sql?
what tools available for managing mysql server? : Sql dba
What is nvarchar in sql?
How to take user input in pl sql?
What is basic structure of pl sql?
What is package in pl sql?
Show how functions and procedures are called in a pl/sql block.
How do I partition a table in sql?
What is the difference between rename and alias?
Explian rowid, rownum? What are the psoducolumns we have?
How do I start sql from command line?
what is 'mysqldump'? : Sql dba
