Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0118:
The specification states the following:
-
Subclause 11.47, "<assertion definition>": <assertion definition> ::= CREATE ASSERTION <constraint name> CHECK <left paren> <search condition> <right paren> [ <constraint characteristics> ] ... Conformance Rules Without Feature F521, "Assertions", conforming SQL language shall not contain an <assertion definition>. Subclause 11.48, "<drop assertion statement>": <drop assertion statement> ::= DROP ASSERTION <constraint name> [ <drop behavior> ] ... Conformance Rules Without Feature F521, "Assertions", conforming SQL language shall not contain a <drop assertion statement>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.