Syntax
{ XML | XMLTYPE }
[ ( maxlength ) ]
[ INLINE LENGTH integer ]
[ attributes [...] ]
Syntax Elements
-
maxlength
- A positive integer value followed by an optional multiplier.
- The multiplier, if specified, is KkMmGg.
-
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 value of maxlength cannot be less than 100 bytes or greater than 2097088000 bytes.
- If maxlength is not specified, the default maximum length used is 2097088000 bytes.
- 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.
-
attributes
- The following data type attributes are supported for the XML type:
- NULL and NOT NULL
- TITLE
- NAMED
- DEFAULT NULL
- Teradata Database does not support column storage or column constraint attributes for the XML type. For more information about the data type attributes, see
Teradata Vantage™ - Data Types and Literals, B035-1143.