What is a primary key, and how is it different from a unique key?
Answer Posted / nashiinformaticssolutions
• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is duration in sql profiler trace?
Can a foreign key be null?
How do you create an update query?
How can one get sql*loader to commit only at the end of the load file? : aql loader
how can we optimize or increase the speed of a mysql select query? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is a table partition?
What is a string data type in sql?
What are sql triggers used for?
How does left join work in sql?
what is the difference between blob and text? : Sql dba
How do I start sql from command line?
What is using in sql?
How to convert comma separated string to array in pl/sql?
what is column? : Sql dba