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.
V0237:
The specification states the following:
-
Subclause 5.4, "Names and identifiers": <sequence generator name> ::= <schema qualified name> ... Conformance Rules Without Feature T176, "Sequence generator support", conforming SQL language shall not contain a <sequence generator name>. Subclause 6.14, "<next value expression>": <next value expression> ::= NEXT VALUE FOR <sequence generator name> ... Conformance Rules Without Feature T176, "Sequence generator support", conforming SQL language shall not contain a <next value expression>. Subclause 11.72, "<sequence generator definition>": <sequence generator definition> ::= CREATE SEQUENCE <sequence generator name> [ <sequence generator options> ] ... Conformance Rules Without Feature T176, "Sequence generator support", conforming SQL language shall not contain a <sequence generator definition>. Subclause 11.73, "<alter sequence generator statement>": <alter sequence generator statement> ::= ALTER SEQUENCE <sequence generator name> <alter sequence generator options> ... Conformance Rules Without Feature T176, "Sequence generator support", conforming SQL language shall not contain an <alter sequence generator statement>. Subclause 11.74, "<drop sequence generator statement>": <drop sequence generator statement> ::= DROP SEQUENCE <sequence generator name> <drop behavior> ... Conformance Rules Without Feature T176, "Sequence generator support", conforming SQL language shall not contain a <drop sequence generator statement>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.