What is a primary key, and how is it different from a unique key?
Answer Posted / glibwaresoftsolutions
• 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 the parts of a basic sql query?
How do I enable sql encryption?
What is the use of sql trace?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Explain what is a column in a table?
What is difference between hql and native sql?
Is primary key clustered index?
How to use transactions efficiently : transact sql
what is the stuff function and how does it differ from the replace function? : Sql dba
Is the primary key an index?
Can a foreign key be a duplicate?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How many types of cursors are available in pl/sql?
What are the methods of filing?
What are the advantages of pl sql?