Unique Index that Allows NULLS

suggest change

CREATE UNIQUE INDEX idx_license_id 
   ON Person(DrivingLicenseID) WHERE DrivingLicenseID IS NOT NULL
GO

This schema allows for a 0..1 relationship - people can have zero or one driving licenses and each license can only belong to one person

Found a mistake? Have a question or improvement idea? Let me know.

Indexes:

* Indexes

* Creating an Index

* 0Clustered Unique and Sorted Indexes

* Sorted Index

* Dropping an Index or Disabling and Rebuilding it

* Partial or Filtered Index

* Inserting with a Unique Index

* Rebuild index

* SAP ASE Drop index

* Unique Index that Allows NULLS

* Clustered index

* Non clustered index

Table Of Contents

0 Getting started with SQL

1 SELECT

2 JOIN

3 Example Databases and Tables

4 UPDATE

5 Indexes

6 CREATE TABLE

7 UNION, UNION ALL

8 ALTER TABLE

9 CASE

10 INSERT

11 Primary Keys

12 ORDER BY

13 GROUP BY

14 Filter results using WHERE and HAVING

15 Window Fnctions

16 Common Table Expressions

17 Views

18 LIKE operator

19 Functions Aggregate

20 DELETE

21 String Functions

22 Data Types

23 AND OR operators

24 Triggers

25 TRUNCATE

26 MERGE

27 Foreign Keys

28 Finding Duplicates on a Column Subset with Detail

29 Sequence

30 Comments

31 Subqueries

32 Execution blocks

33 Stored Procedures

34 DROP Table

35 Row number

36 Transactions

37 CREATE FUNCTION

38 SQL Group by vs. Distinct

39 Table Design

40 CROSS APPLY and OUTER APPLY

41 Synonyms

42 CREATE database

43 SKIP TAKE pagination

44 EXPLAIN and DESCRIBE

45 Information Schema

46 IN clause

47 NULL

48 SQL Injection

49 Cascading Delete

50 Order of Execution

51 DROP or DELETE database

52 EXCEPT

53 TRYCATCH

54 XML

55 GRANT and REVOKE

56 Functions ScalarSingle Row

57 Relational Algebra

58 EXISTS CLAUSE

59 Materialized Views

60 Functions Analytic

61 SQL CURSOR

62 Identifier

63 Clean Code in SQL

64 Contributors