CREATE/REPLACE TRANSFORM Syntax | Teradata Database - CREATE TRANSFORM and REPLACE TRANSFORM Syntax - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Publication Date
June 2025
Content Type
SQL Reference
Publication ID
B035-1144-200K
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
ft:sourceId
dita
dita:id
mdr1472255012272
lifecycle
latest
{ CREATE | REPLACE } TRANSFORM FOR [SYSUDTLIB.] UDT_name
  transform_specification [...] [;]
transform_specification
transform_group ( TO SQL WITH to_method_or_function FROM SQL WITH from_method_or_function )
to_method_or_function
from_method_or_function
{ specific_method | instance_method | specific_function | function }
specific_method
SPECIFIC [SYSUDTLIB.] specific_method_name FOR [SYSUDTLIB.] UDT_name
instance_method
[INSTANCE] METHOD [SYSUDTLIB.] method_name
  ( [ data_type | [SYSUDTLIB.] UDT_name ] [,...] ) FOR [SYSUDTLIB.] UDT_name
specific_function
SPECIFIC FUNCTION [SYSUDTLIB.] specific_function_name
function
FUNCTION [SYSUDTLIB.] function_name
  ( [ data_type | [SYSUDTLIB.] UDT_name ] [,...] )