Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7765 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 is sql better than hql?
What is sql procedures and functions?
What are the different parts of a package?
what is 'mysqld'? : Sql dba
Why do we use cursors?
What is form and report?
What is not equal in sql?
What operators deal with null?
What is a string data type in sql?
Is drop table faster than truncate?
what is a unique key ? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
What is the difference between functions, procedures, and packages in pl/sql?
Can delete statement be rollbacked?
How delete all records from table in sql?
