16.20 - How REPLACE ORDERING Differs From CREATE ORDERING - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The following rules and behaviors differentiate the REPLACE ORDERING and CREATE ORDERING statements:

  • If you specify REPLACE ORDERING, and the specified ordering exists, the system replaces it with the new definition.
  • If the specified ordering does not exist and the associated UDT does not have a defined ordering, then the system creates the specified ordering.
  • If the REPLACE ORDERING statement specifies an ordering for a UDT with which an existing ordering is associated, the system returns an error to the requestor because you can specify only one ordering per UDT.