1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can a unique index be created on a column, which contains null?

Question Posted / meraj ahmed


Can a unique index be created on a column, which contains null?..

Answer / Ankur Kesarwani

No, a unique index cannot be created on a column that allows NULL values because allowing multiple NULL values would violate the uniqueness constraint.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is a field in a table?

1 Answers  

Explain the steps to use transact-sql cursor?

1 Answers  

what is web server?

3 Answers   Satyam,

What are the purpose of Normalisation?

1 Answers   HCL,

What is check constraint in sql server?

1 Answers  

What according to you is the difference between mysql and sql server performance?

1 Answers  

How to find Duplicate Records In table?

1 Answers   HCL,

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1 Answers  

Explain sql server authentication modes?

1 Answers  

1 01 101 01010

1 Answers  

what is diffence between replicaion and logshipping?

1 Answers  

Define left outer join?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories