Table Class Property Descriptions - Teradata Meta Data Services

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 Class Property Descriptions

Table 28: Table Class Property Descriptions
Property Name	Description
CommentString	The comment stored in Teradata for this table.
CreatorName	The Teradata user that created the table.
DatabaseID	Teradata assigned identifier for the database where this table resides.
IsErrorTable	Indicates if the table is the error table for another table. Possible values are Y=Yes, N=No.
IsGlobalTemporary	Indicates if the table is a global temporary table rather than a permanent table. Possible values are Y=Yes, N=No.
LastAlterTimeStamp	Time that Teradata last updated the object.
PartitioningUsed	If the table has a PPI, contains PPI, or else is set null.
PrimaryIndexDefined	Indicates if the table has a primary index. Possible values are Y=Yes, N=No.
SynchronizationLevel	Internal flag.
TableID	Teradata assigned identifier for this table.
Version	Indicates the version of this table in Teradata. Teradata increments the version each time the table is altered.

Table 29: FunctionTable Class Property Descriptions
Property Name	Description
DatabaseID	Teradata assigned identifier for the database containing the function that generates the table.
FunctionID	Teradata assigned identifier for the function that generates the table.
NumberOfColumns	Number of columns in a statically defined table returned by the function. A value of zero indicates that the function was created with the VARYING COLUMNS clause and the number of columns is unknown.
NumberOfDynamicColumns	Maximum number of columns in the table returned by a function defined with the VARYING COLUMNS clause.
SynchronizationLevel	Internal flag.