Column Class Property Descriptions

Teradata Meta Data Services User Guide

Product

Teradata Meta Data Services

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

Product Category

Teradata Tools and Utilities

Table 30: Column Class Property Descriptions
Property Name	Description
CharType	Specifies the character set type of character fields. Values can be: 1 Latin 2 Unicode 3 KanjiSJIS 4 Graphic 5 Kanji1
ColumnFormat	Display format for the column.
ColumnID	Teradata assigned identifier for this column.
ColumnLength	Maximum size of the column.
ColumnTitle	Heading for displayed or printed results that is different from the column name, which is used by default.
ColumnType	Column data type. Values can be: A1 1-dimensional Array AN n-dimensional Array AT Time BF Byte BO BLOB BV VarByte CF Character CO CLOB CV VarCharacter D Decimal DA Date DH Day To Hour DM Day To Minute DS Day To Second DY Day F Float HM Hour To Minute HR Hour HS Hour To Second I Integer I1 ByteInt I2 SmallInt I8 BigInt	JN JSON MI Minute MO Month MS Minute To Second N Number PD Period Date PM Period Timestamp with Time Zone PS Period Timestamp PT Period Time PZ Period Time with Time Zone SC Second SZ Timestamp with Time Zone TS Timestamp TZ ANSI Time with Time Zone UT User-defined Type VA TD_VALIST XM XML YM Year To Month YR Year
CommentString	The comment stored in Teradata for this column
Compressible	Indicates if the column is to be compressed. If yes, column will be compressed to zero space if the data value of the column is equal to the CompressValue. C = Multi-value compression N = Non-compress A = Algorithmic compression U = UDT Internal compression
CompressValue	If NULL is specified, NULLs are compressed. If one or more constants are specified, NULLS and the values are compressed.
DatabaseID	Teradata assigned identifier for the database where this column resides
DecimalFractDigits	Number of digits in the decimal portion of data types of DECIMAL and NUMERIC
DecimalTotalDigits	Total number of digits for data types of DECIMAL and NUMERIC
DefaultValue	Default value specified for this column
DerivedPeriod	Is this column a derived period column or part of a derived period? Values are: Yes = is a derived period column No = is not part of a derived period definition Period Begin = the starting column of a derived period definition Period End = the ending column of a derived period definition
IDColType	If this is an identity column, this field contains the parameters defined for the identity column.
IsSecurityConstraint	Does this column represent a security constraint defined for the table? Y=Yes N=No
Nullable	Indicates if NULL is an accepted value for this column. Y/N Y = acceptable value N = not acceptable value
TableID	Teradata assigned identifier for the table where this column resides
UppercaseFlag	If a column is declared UPPERCASE, then the small-case letters are converted and stored in their capital-case equivalents. Y = small-case converted N = small-case not converted