what are the advantages of primary key over unique+notnull
Answer Posted / kamal
we are able to create a primary key for combination of more
than 1 column. which is not possible in Unique,we should
create unique key for each and every column in the table
individually.
ex . we can create a primary key for (Name,DOB,address)- ie
combination of these three columns be unique.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are character functions?
How do you rename a table in sql?
What is the difference between Union and Union all. Which is faster.
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
How many sql core licenses do I need?
Is sql easier than java?
what is difference between delete and truncate commands? : Sql dba
What is field delimiter?
how mysql optimizes distinct? : Sql dba
How to pronounce postgresql?
Why do we use sql constraints?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
what is union? : Sql dba
what is a view? : Sql dba
What are expressions?