what are the advantages of primary key over unique+notnull
Answer Posted / soubhagya
When we create a primary key automatically a cluster index
is created on those columns involved in primary key.But
this index not created in unique+not null key, it only
restrict the duplicate values.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is procedure explain with program?
what are the differences between char and varchar? : Sql dba
What is sorting in sql?
Can we use ddl statements in stored procedure sql server?
How do you optimize a stored procedure in sql?
What is before and after trigger?
How to combine two stored procedures in sql?
What is pl sql package?
what is msql? : Sql dba
how can we submit a form without a submit button? : Sql dba
What is null in pl/sql?
How do you remove duplicates without using distinct in sql?
What is the use of function in sql?
What is the command used to fetch first 5 characters of the string?
How do we accept inputs from user during runtime?