Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 18640 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hameed
Primary key does not allow any null value in a table where
as Unique key allows only one null value
Primary key is by default a Clustered Index where as Unique
key is a non-clustered index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to provide column names in insert statements in ms sql server?
Find nth lowest salary or get nth lowest salary?
What are the common performance issues in sql server?
Delete duplicate rows without using rowid.
List out some of the requirements to set up a sql server failover cluster?
Explain about system database?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to list all columns in a table using odbc_columns()?
How is SQL Azure different than SQL server?
What is PROJECTION Operation?
How to automatically create a log when an exception is being received into SQL Server?
How to delete duplicate rows in sql server?
What is the difference between DATETIME2 and DATETIME?
What are the properties of sub-query?
Define cross join in sql server joins?
