what is the different between unique+not null & primary key,
Answer Posted / giri
unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are properties of the transaction?
What is column?
What is the difference between a primary key and a clustered index?
What is trigger and stored procedure in sql?
What is the difference between nvl function, ifnull function, and isnull function?
How do you determine the current isolation level? : Transact sql
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Can we create clustered index without primary key?
Is left join inner or outer?
How many unique keys can a table have?
Does asenumerable execute the query?
How many tables can you join in sql?
What is difference between joins and union?
What is using in sql?
How many aggregate functions are available there in sql?