What's the difference between a primary key and a unique key?
- 10 Answers
- 16018 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / karthick
PRIMARY KEY AND UNIQUE KEY
* Both Enforces Uniqueness
* Primary key Creates clustered index
unique key creates non clustered index
* primay key does not allows null value
unique key allows 1 null value
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the difference between seek predicate and predicate?
How do I delete a sql server database?
What is logon trigger?
Define msdb database?
How to skip remaining statements in a loop block using continue statements?
Why variables called the most powerful component of ssis?
How do you run a trace?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How do you delete a data source?
What are character string data types in ms sql server?
Can we update data in a view?
What is the difference between char and varchar2 datatype in sql?
What is difference between views and stored procedures?
What are trace files?
can you instantiate a com object by using t-sql? : Sql server database administration
