How to create a unique index on a NULL column?

by

Using SQL Server 2008, you can create a filtered index.

CREATE UNIQUE INDEX AK_MyTable_Column1 ON MyTable (Column1) WHERE Column1 IS NOT NULL

Another option is a trigger to check uniqueness, but this could affect performance.

More Related Contents:

  1. Foreign key constraint may cause cycles or multiple cascade paths?
  2. How important is the order of columns in indexes?
  3. Creating an index on a table variable
  4. What are Covering Indexes and Covered Queries in SQL Server?
  5. SQL Server indexes – ascending or descending, what difference does it make?
  6. SQL Server 2005 How Create a Unique Constraint?
  7. Turn off constraints temporarily (MS SQL)
  8. Does Foreign Key improve query performance?
  9. Postgres unique constraint vs index
  10. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  11. How to select only the first rows for each unique value of a column?
  12. SQL Server 2008- Get table constraints
  13. Deferrable Constraints in SQL Server
  14. sql unique constraint on a 2 columns combination
  15. What’s the difference between a Table Scan and a Clustered Index Scan?
  16. Slow bulk insert for table with many indexes
  17. Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]
  18. Select top 10 records for each category
  19. What this query does to create comma delimited list SQL Server?
  20. Write a number with two decimal places SQL Server
  21. Selecting N rows in SQL Server
  22. A SQL Query to select a string between two known strings
  23. How can I INSERT data into two tables simultaneously in SQL Server?
  24. Group DateTime into 5,15,30 and 60 minute intervals
  25. Column name or number of supplied values does not match table definition
  26. SQL Group BY, Top N Items for each Group
  27. SQL UPDATE TOP with ORDER BY?
  28. How do I create a table alias in MySQL
  29. SUM total time in SQL Server [duplicate]
  30. can we have a foreign key which is not a primary key in any other table?

Leave a Comment