Share via


2.1.2.140 S094, Arrays of reference types

V0176:

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>
  
 ...
  
 <reference type> ::=
 REF <left paren> <referenced type> <right paren> [ <scope clause> ]
  
 ...
  
 <array type> ::=
 <data type> ARRAY
 [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ]
  
 ...
  
 Conformance Rules
  
 Without Feature S094, "Arrays of reference types", conforming SQL language shall not contain an <array type> that is based on a <data type> that contains a <reference type>.
  

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

Transact-SQL does not support this feature.