15.00 - CREATE ORDERING/REPLACE ORDERING - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

CREATE ORDERING/
REPLACE ORDERING

How REPLACE ORDERING Differs From CREATE ORDERING

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.