Share via

2.1.2.166 S291, Unique constraint on entire row

  • Article

V0202:

The specification states the following:

 Subclause 11.7, "<unique constraint definition>":
  
 <unique constraint definition> ::=
 <unique specification> <left paren> <unique column list> <right paren>
 | UNIQUE ( VALUE )
  
 <unique specification> ::=
 UNIQUE
 | PRIMARY KEY
  
 <unique column list> ::=
 <column name list>
  
 ...
  
 Conformance Rules
  
 Without Feature S291, "Unique constraint on entire row", conforming SQL language shall not contain UNIQUE(VALUE).

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

Transact-SQL does not support this feature.