2.1.1.16 E141, Basic integrity constraints

V0016:

The specification states the following:

 Subclause 11.6, "<table constraint definition>":
  
 <table constraint definition> ::=
 [ <constraint name definition> ] <table constraint>
 [ <constraint characteristics> ]
  
 <table constraint> ::=
 <unique constraint definition>
 | <referential constraint definition>
 | <check constraint definition>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature.