what is the different between unique+not null & primary key,
- 4 Answers
- 6397 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
Is it possible to link two groups inside a cross products after the cross products group has been created?
What are the basic sql commands?
What is the difference between syntax error and runtime error?
How does one load ebcdic data? : aql loader
Why function is used in sql?
What is the syntax to add a record to a table?
How is debugging done?
What is delimiter in pl sql?
What is a null value?
What does inner join mean?
What types of commands can be executed in sql*plus?
how to use regular expression in pattern match conditions? : Sql dba
How to get help at the sql prompt?
What is time based sql injection?
What does subquery mean in sql?
