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.
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.