Interested to Buy Any Domain ? << Click Here >> for more details...
What is differance unique key and primary key.
- 7 Answers
- 11294 Views
- EDS, I also Faced
- E-Mail Answers
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
Write a query to display the current date in sql?
Write a sql query to convert all character to uppercase after hypen.
What is the advantage of nosql?
How do I view a view in sql?
Explain the difference between sql and mysql.
What is integrity in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can we call stored procedure in function?
Can a composite key be null?
Explain what is rdbms?
How is sql used in oracle?
What is a design view?
What are conditional predicates?
What is Materialized View? In What Scenario we Use Materialized View?
What is a record in a database?
