F031-16, DROP VIEW statement: RESTRICT clause


The specification states the following:

 Subclause 11.33, "<drop view statement>":
 With a <drop behavior> of RESTRICT
 <drop view statement> ::=
 DROP VIEW <table name> <drop behavior>
 Subclause 11.2, "<drop schema statement>":
 <drop behavior> ::=

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

Transact-SQL does not support this feature. The DROP VIEW statement exists in Transact-SQL, but the statement does not support the RESTRICT keyword.