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 all ddl commands?
What are functions in sql?
How do temporal tables work?
How is debugging done?
Why do we need sharding?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Is id a reserved word in sql?
Is sql low level language?
Explain the steps needed to create the scheduled job?
Why cross join is used?
Why primary key is required?
what is the difference between undefined value and null value? : Sql dba
What is difference between db2 and sql?
What is the difference between the implicit and explicit cursors?
How do I send sql query results to excel?