What is differance unique key and primary key.
Answer Posted / madhu
unique key:
1.unique key will accept more than one null value.
2.whenever u created a unique key, then internally one non-clustered index will be created(one table can have more than one Non-clustered index).
3.one table can have more than one unique key.
Primary key:
1.One table should have one primary key only.
2.primary key will not accept null values.
3.whenever u created a primary key then internally one clustered index will be created(one table can have only one clustered index).
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between $message and $$message? : Sql dba
What is sql constant?
What is trigger in sql and its types?
What is keys and its types?
How do you write an index?
Which are the different character-manipulation functions in sql?
Is oracel sql developer written in java?
Explain the purpose of %type and %rowtype data types?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is t-sql? : Transact sql
What are crud methods?
What are the possible values for the boolean data field?
How do you use join?
What is sql partition function?
how to select first 5 records from a table? : Sql dba