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.
V0098
The specification states the following:
-
Subclause 11.20, "<alter identity column specification>": <alter identity column specification> ::= <set identity column generation clause> [ <alter identity column option>... ] | <alter identity column option>... <set identity column generation clause> ::= SET GENERATED { ALWAYS | BY DEFAULT } <alter identity column option> ::= <alter sequence generator restart option> | SET <basic sequence generator option> ... Conformance Rules: Without Feature F386, "Set identity column generation clause", conforming SQL language shall not contain a <set identity column generation clause>.
Microsoft SQL Server 2008 R2varies as follows:
This feature is absent from the [ISO/IEC9075-2:2008] standard.
Microsoft SQL Server 2012 varies as follows:
Transact-SQL does not support this feature.