Share via


2.1.2.97 F701, Referential update actions

V0133:

The specification states the following:

 Subclause 11.8, "<referential constraint definition>":
  
 <referential triggered action> ::=
 <update rule> [ <delete rule> ]
 | <delete rule> [ <update rule> ]
  
 <update rule> ::=
 ON UPDATE <referential action>
  
 <delete rule> ::=
 ON DELETE <referential action>
  
 ...
  
 Conformance Rules
  
 Without Feature F701, "Referential update actions", conforming SQL language shall not contain an <update rule>.

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

Transact-SQL partially supports this feature. See the ON UPDATE clause and related clauses of the CREATE TRIGGER [MSDN-CTGTS] and ALTER TRIGGER [MSDN-ALTERTRIGGER] statements for equivalent functionality.