17.10 - How REPLACE ORDERING Differs From CREATE ORDERING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.