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 are the benefits of stored procedures?
What is a primary key? Explain
Does sql full backup truncate logs?
What are different clauses used in sql?
What does pl sql developer do?
What is sql performance tuning?
how to drop an existing index in mysql? : Sql dba
What is the difference between sql, mysql and sql server?
What is java sql drivermanager?
How do I save a sql query?
What are sql data types?
How do you use collections in procedure to return the resultset?
What are sql built in functions?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How do I install microsoft sql?