Share via


2.1.2.42 F202, TRUNCATE TABLE: identity column restart option

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.