15.10 - UNIQUE - Teradata Database

Any two rows in the table cannot have the same value or combination of values in the indexed columns.

You cannot specify UNIQUE for a secondary index:

• if you also specify ALL.
• for a secondary index defined on a join index.
• if you also specify an ORDER BY clause.
• for a column that has a LOB UDT or XML data type.