Share via


2.1.2.132 S051, Create table of type

V0168:

The specification states the following:

 Subclause 11.3, "<table definition>":
  
 <typed table clause> ::=
 OF <path-resolved user-defined type name> [ <subtable clause> ]
 [ <typed table element list> ]
  
 ...
  
 Conformance Rules
  
 Without Feature S051, "Create table of type", conforming SQL language shall not contain "OF <path-resolved user-defined type name>".
  
 Subclause 11.32, "<view definition>":
  
 <referenceable view specification> ::=
 OF <path-resolved user-defined type name> [ <subview clause> ]
 [ <view element list> ]
  
 Subclause 6.1, "<data type>":
  
 <path-resolved user-defined type name> ::=
 <user-defined type name>
  
 Subclause 5.4, "Names and identifiers":
  
 <user-defined type name> ::=
 [ <schema name> <period> ] <qualified identifier>

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

Transact-SQL does not support this feature. For more details, see feature S023 (section 2.1.2.124).