Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7607 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
Can we write ddl statements in functions?
What sql does db2 use?
What is the use of double ampersand (&&) in sql queries? Give an example
How to run sql*plus commands in sql developer?
What is normalization in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Why is a primary key important?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What does 0 mean in sql?
What is an inconsistent dependency?
Can we rollback truncate?
define sql update statement ? : Sql dba
How do I view a procedure in sql?
what is a view? : Sql dba
What is java sql connection?
