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.
V0078
The specification states the following:
-
Subclause 14.10, "<truncate table statement>": <truncate table statement> ::= TRUNCATE TABLE <target table> [ <identity column restart option> ] <identity column restart option> ::= CONTINUE IDENTITY | RESTART IDENTITY ... Conformance Rules: Without Feature F202, "TRUNCATE TABLE: identity column restart option", conforming SQL language shall not contain an <identity column restart option>.
Microsoft SQL Server 2008 R2 varies 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.