Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7571 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
Why do we use joins?
write an sql query to find names of employee start with 'a'? : Sql dba
What are the types of keys?
What is the difference between partitioning and sharding?
What are the events on which a database trigger can be based?
what are sequences
how is myisam table stored? : Sql dba
Why we use triggers in mysql?
What is dml statement?
What types of commands can be executed in sql*plus?
What is file based approach?
Is stored procedure faster than query?
Explain raise_application_error.
What is the difference between stored procedure and view?
what are the differences between char and varchar? : Sql dba
