Share via


2.1.2.197 T172, AS subquery clause in table definition

V0233:

The specification states the following:

 Subclause 11.3, "<table definition>":
  
 <as subquery clause> ::=
 [ <left paren> <column name list> <right paren> ] AS <table subquery>
 <with or without data>
  
 <with or without data> ::=
 WITH NO DATA
 | WITH DATA
  
 ...
  
 Conformance Rules
  
 Without Feature T172, "AS subquery clause in table definition", conforming SQL language shall not contain an <as subquery clause>.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.