What is a primary key, and how is it different from a unique key?
Answer Posted / hr@tgksolutions.com
• 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 are different types of keys?
What is delete command in sql?
What is a dirty read sql?
How to install oracle sql developer?
what is a stored procedure? : Sql dba
How do you know if a relationship is 2nf?
What is multiple partition?
What is union?
What is pl sql variable?
What is a stored procedure in sql with example?
is mysql query is case sensitive? : Sql dba
what are the limitations of identity column? : Transact sql
Why do we use view in sql?
How many columns should be in an index?
How many clustered indexes can be created on a table?