2.1.1.23 F031-13, DROP TABLE statement: RESTRICT clause

  • Article
  • 2 minutes to read

V0023:

The specification states the following:

 Subclause 11.31, "<drop table statement>":
 With a <drop behavior> of RESTRICT
  
 <drop table statement> ::=
 DROP TABLE <table name> <drop behavior>
  
 Subclause 11.2, "<drop schema statement>":
  
 <drop behavior> ::=
 CASCADE
 | RESTRICT

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

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