what is the different between unique+not null & primary key,
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
what is row? : Sql dba
What does trigger mean in psychology?
how to start mysql server? : Sql dba
What is an invalid partition table?
What is a parameter query?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is native sql query?
How do I order by ascending in sql?
What is the difference between the implicit and explicit cursors?
How can the performance of a trigger be improved?
What is over () in sql?
How does a self join work?
what is “go” in t-sql? : Transact sql
Mention what is the plv (pl/vision) package offers?
How does stored procedure reduce network traffic?