What's the difference between a primary key and a unique key?
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
What is normalization process?
When is update_statistics command used?
What is usually the first word in a sql query?
Explain the dirty pages?
How to connect to a sql server using odbc_connect()?
What is a livelock?
What number aggregate functions are accessible there in sql?
Write the syntax for stuff function in an sql server?
How to retrieve field values using mssql_result()?
What functions can a view be used to performed?
How to add a new dsn with the odbc driver for sql server?
What is cdc in sql server?
How to view the error log for any specific instance? : sql server database administration
Explain index in sql server?
What function does a database engine serve in the sql server?