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 a memo field?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
What are the basic sql commands?
What is a pdo connection?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is coalesce sql?
What are the types of keys?
What are the parts of a basic sql query?
what is the command line end user interface - mysql? : Sql dba
How do I find duplicates in a single column in sql?
What is the most restrictive isolation level? : Transact sql
What is sql profiler in oracle?
How do I clear the screen in sql plus?
What are the different types of joins in sql?