ST_Geometry Type Syntax | Geospatial Data Types | Teradata Vantage - 17.10 - ST_Geometry Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
[SYSUDTLIB.] ST_GEOMETRY
  [ ( maxlength ) ]
  [ INLINE LENGTH integer ]
  [ attribute [...] ]

Syntax Elements

SYSUDTLIB.
The name of the database in which all UDTs are created.
maxlength
A positive integer value followed by an optional multiplier.
maxlength specifies the maximum length of the data type in bytes. You can define a maximum length on a per instance basis. When specified, the data type is used in a manner analogous to the VARBYTE or BLOB data types.
The length specified only covers the actual data length. The actual storage sizes include additional header information.
The default value is approximately 16 MB.
You can find the actual size of ST_Geometry objects by using the DataSize system function.
INLINE LENGTH integer
A positive integer value which specifies the inline storage size. Data that is smaller than or equal to the inline storage size is stored inside the base row; otherwise, it is stored in a LOB subtable.
The inline length cannot be larger than maxlength.
The default value is approximately 10,000 bytes.
attribute
Appropriate data attributes.
An ST_GEOMETRY column supports the following attributes:
  • NULL
  • NOT NULL
  • FORMAT
  • TITLE
  • NAMED
  • DEFAULT NULL
For more information on using the data attributes, see Teradata Vantageā„¢ - Data Types and Literals, B035-1143.

An ST_GEOMETRY column does not support column storage or column constraint attributes.