2.1.2.77 F492, Optional table constraint enforcement

V0113

The specification states the following:

 Subclause 10.8, "<constraint name definition> and <constraint characteristics>":
  
 <constraint name definition> ::=
 CONSTRAINT <constraint name>
  
 <constraint characteristics> ::=
 <constraint check time> [ [ NOT ] DEFERRABLE ] [ <constraint enforcement> ]
 | [ NOT ] DEFERRABLE [ <constraint check time> ] [ <constraint enforcement> ]
 | <constraint enforcement>
  
 <constraint check time> ::=
 INITIALLY DEFERRED
 | INITIALLY IMMEDIATE
  
 <constraint enforcement> ::=
 [ NOT ] ENFORCED
  
 ...
  
 Conformance Rules:
  
 Without Feature F492, "Optional table constraint enforcement", conforming SQL language shall not contain a <constraint characteristics>, that specifies <constraint enforcement>.
  
 Subclause 11.25, "<alter table constraint definition>":
  
 <alter table constraint definition> ::=
 ALTER CONSTRAINT <constraint name> <constraint enforcement>
  
 ...
  
 Conformance Rules:
  
 Without Feature F492, "Optional table constraint enforcement", conforming SQL language shall not contain an <alter table constraint definition> that contains a <constraint enforcement>.
  

Microsoft SQL Server 2008 R2varies as follows:

This feature is absent from the [ISO/IEC9075-2:2008] standard.

Microsoft SQL Server 2012 varies as follows:

Transact-SQL does not support this feature.