MBB Syntax | Geospatial Data Types | Teradata Vantage - 17.05 - Syntax - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K

Use the following syntax to specify an MBB data type in a column definition.

[SYSUDTLIB.] MBB [ attribute [...] ]
SYSUDTLIB.
The database that contains the definition of the Teradata Database MBR data type.
attribute
A column defined as data type MBB supports the following data type attributes:
  • NULL
  • NOT NULL
  • FORMAT
  • TITLE
  • NAMED
  • DEFAULT NULL
For more information on using these data type attributes, see Teradata Vantageā„¢ - Data Types and Literals, B035-1143.
An MBB column does not support column storage or column constraint attributes.