Share via


2.1.2.168 S401, Distinct types based on array types

V0204:

The specification states the following:

 Subclause 6.1, "<data type>":
  
 <collection type> ::=
 <array type>
 | <multiset type>
  
 <array type> ::=
 <data type> ARRAY
 [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ]
  
 Subclause 11.51, "<user-defined type definition>":
  
 <representation> ::=
 <predefined type>
 | <collection type>
 | <member list>
  
 ...
  
 Conformance Rules:
  
 Without Feature S401, "Distinct types based on array types", in conforming SQL language, <representation> shall not contain <array type>.

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.