15.00 - CREATE TRANSFORM/REPLACE TRANSFORM - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

CREATE TRANSFORM/
REPLACE TRANSFORM

How REPLACE TRANSFORM Differs From CREATE TRANSFORM

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

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