2.1.2.202 T178, Identity columns: simple restart option

V0238:

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 T178, "Identity columns: simple restart option", in conforming SQL language, an <alter sequence generator restart option> contained in an <alter identity column specification> shall contain a <sequence generator restart value>.
  
 Subclause 11.73, "<alter sequence generator statement>":
  
 <alter sequence generator restart option> ::=
 RESTART [ WITH <sequence generator restart value> ]
  
 <sequence generator restart value> ::=
 <signed numeric literal>

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.