How REPLACE ORDERING Differs From CREATE ORDERING - Teradata Vantage - Analytics Database

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.