what is the different between unique+not null & primary key,
Answer Posted / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of sql?
How delete all records from table in sql?
How can triggers be used for the table auditing?
What is trigger in flip flop?
Which are the different types of indexes in sql?
Does sql support programming?
Is oracle and sql same?
What is difference between inner join and cross join?
What is user defined functions?
How do I view a view in sql?
Why is sql*loader direct path so fast?
What is the difference between between and in condition operators?
Do foreign keys improve performance?
What is the purpose of normalization?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba