Share via


2.1.2.139 S092, Arrays of user-defined types

V0175:

The specification states the following:

 Subclause 6.1, "<data type>":
  
 <data type> ::=
 <predefined type>
 | <row type>
 | <path-resolved user-defined type name>
 | <reference type>
 | <collection type>
  
 ...
  
 <path-resolved user-defined type name> ::=
 <user-defined type name>
  
 ...
  
 <array type> ::=
 <data type> ARRAY
 [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ]
  
 ...
  
 Conformance Rules
  
 Without Feature S092, "Arrays of user-defined types", conforming SQL language shall not contain an <array type> that is based on a <data type> that contains a <path-resolved user-defined type name>.
  

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

Transact-SQL does not support this feature.