Share via


2.1.2.41 F191, Referential delete actions

V0077

The specification states the following:

 Subclause 11.8, "<referential constraint definition>":
  
 <delete rule> ::=
 ON DELETE <referential action>
  
 <referential action> ::=
 CASCADE
 | SET NULL
 | SET DEFAULT
 | RESTRICT
 | NO ACTION
  
 ...
  
 Conformance Rules
  
 Without Feature F191, "Referential delete actions", conforming SQL language shall not contain a <delete rule>.

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

Transact-SQL partially supports this feature. The ON DELETE RESTRICT rule is not supported.