ColumnsV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Schema

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a database.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a table, view, stored procedure, or macro.
ColumnName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the column or parameter.
ColumnFormat VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the format of column or parameter.
ColumnTitle VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Returns the heading for the column.
SPParameterType CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns the data type of a stored procedure parameter and is also used as the data type of a UDF/UDM.
ColumnType CHAR(2) LATIN UPPERCASE X(2) Returns the type of data in a table or view column, or stored procedure or macro parameter.
ColumnUDTName VARCHAR(128) UNICODE UPPERCASE X(128) Returns the name of a UDT if that column data type is a UDT.
ColumnLength INTEGER Z,ZZZ,ZZZ,ZZ9 Returns the length of a column as the maximum number of bytes used to physically store a column value in a table row.
DefaultValue VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Returns any default value assigned to the column or parameter.
Nullable CHAR(1) LATIN UPPERCASE X(1) Returns a code to indicate whether or not a column may have a null value.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns user-supplied text or commentary on the column, database, table, view, macro, user-defined function, user-defined types, user-defined methods, stored procedure, role, profile, or user.
DecimalTotalDigits SMALLINT -ZZ9 Returns an integer indicating the total number of decimal digits (if the column is defined as a decimal).
DecimalFractionalDigits SMALLINT -ZZ9 Returns an integer indicating the total number of fractional digits (if the column is defined as a decimal).
ColumnId SMALLINT NOT NULL ---,--9 Returns the internal identifier assigned to the column by the DBC.
UpperCaseFlag CHAR(1) LATIN UPPERCASE X(1) Returns the case indicator flag for the column, and whether comparisons on the column are case specific.
Compressible CHAR(1) LATIN NOT CASESPECIFIC X(1) Compressible indicates whether the column can be compressed and the type of compression defined for the column.
CompressValue NULL NULL Returns the column is removed from tvfields so NULL is being returned.
ColumnConstraint VARCHAR(8192) UNICODE NOT CASESPECIFIC X(8192) Returns the condition text for column level Check.
ConstraintCount SMALLINT NOT NULL ---,--9 Returns the count of table level constraints referencing this column.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who executed the CREATE statement.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.
LastAlterName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the user who last updated the dictionary row.
LastAlterTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time the dictionary row was last updated.
CharType SMALLINT ---,--9 Returns the type of the different character data types.
IdColType CHAR(2) LATIN UPPERCASE X(2) Indicates if a column is a regular column or an identity column.
AccessCount BIGINT --,---,---,---,---,---,--9 Returns the access count for the corresponding database object.
LastAccessTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time that the corresponding object was last accessed.
CompressValueList VARCHAR(8192) UNICODE NOT CASESPECIFIC X(8192) Returns the algorithm names in addition to the compress values.
TimeDimension CHAR(1) LATIN UPPERCASE X(1) Returns the ValidTime and TransactionTime properties for a period column.
VTCheckType CHAR(1) LATIN UPPERCASE X(1) Returns the ValidTime dimension information for the CHECK condition.
TTCheckType CHAR(1) LATIN UPPERCASE X(1) Returns the TransactionTime dimension for the CHECK constraint on a table with TransactionTime.
ConstraintId BYTE(4) X(8) The DBC.COLUMNSVX.ConstraintId field contains the id of the security constraint if it is a security constraint column.
ArrayColNumberOfDimensions BYTEINT -(3)9 The DBC.ColumnsVX.ArrayColNumberOfDimensions field contains a numeric value that indicates the number of dimensions for an ARRAY type column.
ArrayColScope VARCHAR(3200) LATIN UPPERCASE X(3200) The DBC.ColumnsVX.ArrayColScope field contains a string of the format '[n:m]...' which describes the lower and upper bounds values for each dimension of the ARRAY type column.
ArrayColElementType CHAR(2) LATIN UPPERCASE X(2) The DBC.ColumnsVX.ArrayColElementType field contains a 2-character data type code for the element of an ARRAY type column.
ArrayColElementUdtName VARCHAR(128) UNICODE UPPERCASE X(128) The DBC.ColumnsVX.ArrayColElementUdtName field contains a UDT Name when the element's data type of an ARRAY type column is UDT.
PartitioningColumn CHAR(1) LATIN UPPERCASE NOT NULL X(1) DBC.ColumnsVX.PartitioningColumn is N if not a partitioning column and Y if a partitioning column in a partitioning expression.
ColumnPartitionNumber BIGINT NOT NULL -(19)9 DBC.ColumnsVX.ColumnPartitionNumber is 0 if not column partitioned
ColumnPartitionFormat CHAR(2) LATIN UPPERCASE NOT NULL X(2) DBC.ColumnsVX.ColumnPartitionFormat is NA if not applicable (i.e., not column partitioned). First character: C = COLUMN format, R = ROW format. Second character: S = system-determined, U = user-specified.
ColumnPartitionAC CHAR(2) LATIN UPPERCASE NOT NULL X(2) DBC.ColumnsVX.ColumnPartitionAC is NA if not applicable (i.e., not column partitioned), NC if no auto compress, and AC if auto compress.
PseudoUDTFieldId SMALLINT ---,--9 The PseudoUDTFieldId field specifies the field id of the derived period column in the table in which the begin or end column of the derived period column participate; otherwise NULL.
PseudoUDTFieldType CHAR(2) LATIN UPPERCASE X(2) The PseudoUDTFieldType specifies whether the column is a derived period column or begin column of a derived period column or end column of a derived period column; otherwise NULL.
StorageFormat VARCHAR(6) UNICODE NOT CASESPECIFIC X(6) The StorageFormat specifies the storage format of a any column which has multiple storage formats, or a NULL value if the column does not have this characteristic.
DatasetSchemaName VARCHAR(128) UNICODE UPPERCASE X(128) The name of a schema associated with a DATASET data type column, or a NULL value if the column is not a DATASET data type or does not have a schema associated with it.
InlineLength INTEGER --,---,---,--9 Returns the inline length of a UDT.
TSColumnType CHAR(2) LATIN UPPERCASE X(2) The TSColumnType identifies a Time Series column type of TimeBucket, TimeCode or SeqNo; NULL if a column does not fall into these types.
AutoColumn CHAR(1) LATIN UPPERCASE X(1) Returns if a column is an AUTO COLUMN.
RowVersionNo SMALLINT ---,--9 Returns the row version number.