15.10 - source_data_type - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

Either a structured or distinct UDT or any valid predefined data type. You cannot specify an ARRAY or VARRAY type. For a list of data types, see Data Types Syntax.

Either source_data_type or target_data_type or both must be a UDT. This can be either a user-created UDT or an internal UDT.

If source_data_type is a predefined data type, then its cast routine must be a cast function. See SPECIFIC FUNCTION.

Example: Casting Source Data as VARCHAR

The following CREATE CAST request creates a cast operation that converts the source data type circle to the target data type VARCHAR(32) using the method having the specific method name circleToVarchar.

     CREATE CAST (circle AS VARCHAR(32))
     WITH SPECIFIC METHOD SYSUDTLIB.circleToVarchar