what are the advantages of primary key over unique+notnull
Answer Posted / tulsi
Primary key will avoid duplicate and null values in a table
which the combination of unique+not null will do.But the
advantage is,if a table has primary key we can create
relation to child tables.
| Is This Answer Correct ? | 28 Yes | 13 No |
Post New Answer View All Answers
What is the difference between rename and alias?
How do you truncate?
What is string data type in sql?
What are dml commands?
How do I partition a table in sql?
What is rank () in sql?
What is sqlerrm?
What are the topics in pl sql?
what is clause? : Sql dba
What are the advantages of pl sql over sql?
Is sql a oracle?
Can you have more than one key in a database?
What is synonyms?
What is dml statement?
What is relationship? How many types of relationship are there?