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.
V0021:
The specification states the following:
-
Clause 13, "SQL-client modules" Subclause 13.1, "<SQL-client module definition>": <SQL-client module definition> ::= <module name clause> <language clause> <module authorization clause> [ <module path specification> ] [ <module transform group specification> ] [ <module collations> ] [ <temporary table declaration>... ] <module contents>... <module authorization clause> ::= SCHEMA <schema name> | AUTHORIZATION <module authorization identifier> [ FOR STATIC { ONLY | AND DYNAMIC } ] | SCHEMA <schema name> AUTHORIZATION <module authorization identifier> [ FOR STATIC { ONLY | AND DYNAMIC } ]
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. Transact-SQL supports embedded language features instead.