Category: Schema
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a database. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a table, view, stored procedure, or macro. |
| ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the column or parameter. |
| ColumnFormat | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The format of column or parameter. |
| ColumnTitle | VARCHAR(256) UNICODE NOT CASESPECIFIC | X(256) | The heading for the column. |
| SPParameterType | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | The data type of a stored procedure parameter and is also used as the data type of a UDF. |
| ColumnType | CHAR(2) LATIN UPPERCASE | X(2) | The type of data in a table or view column, or stored procedure or macro parameter. |
| ColumnUDTName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The name of a UDT if that column data type is a UDT. |
| ColumnLength | INTEGER | Z,ZZZ,ZZZ,ZZ9 | 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) | Any default value assigned to the column or parameter. |
| Nullable | CHAR(1) LATIN UPPERCASE | X(1) | A code to indicate whether a column may have a null value. |
| CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | User-supplied text or commentary on the column, database, table, view, macro, user-defined function stored procedure, role, profile, or user. |
| DecimalTotalDigits | SMALLINT | -ZZ9 | An integer indicating the total number of decimal digits (if the column is defined as a decimal). |
| DecimalFractionalDigits | SMALLINT | -ZZ9 | An integer indicating the total number of fractional digits (if the column is defined as a decimal). |
| ColumnId | SMALLINT NOT NULL | ---,--9 | The internal identifier assigned to the column by the DBC. |
| UpperCaseFlag | CHAR(1) LATIN UPPERCASE | X(1) | 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 | The column is removed from tvfields so NULL is being returned. |
| ColumnConstraint | VARCHAR(8192) UNICODE NOT CASESPECIFIC | X(8192) | The condition text for column level Check. |
| ConstraintCount | SMALLINT NOT NULL | ---,--9 | 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 ran the CREATE statement. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time the dictionary row was last updated. |
| CharType | SMALLINT | ---,--9 | 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 | The access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time that the corresponding object was last accessed. |
| CompressValueList | VARCHAR(8192) UNICODE NOT CASESPECIFIC | X(8192) | The algorithm names and the compress values. |
| TimeDimension | CHAR(1) LATIN UPPERCASE | X(1) | The ValidTime and TransactionTime properties for a period column. |
| VTCheckType | CHAR(1) LATIN UPPERCASE | X(1) | The ValidTime dimension information for the CHECK condition. |
| TTCheckType | CHAR(1) LATIN UPPERCASE | X(1) | The TransactionTime dimension for the CHECK constraint on a table with TransactionTime. |
| ConstraintId | BYTE(4) | X(8) | For security constraint column, ID of the security constraint. |
| ArrayColNumberOfDimensions | BYTEINT | -(3)9 | Numeric value that indicates the number of dimensions for an ARRAY type column. |
| ArrayColScope | VARCHAR(3200) LATIN UPPERCASE | X(3200) | 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) | A 2-character data type code for the element of an ARRAY type column. |
| ArrayColElementUdtName | VARCHAR(128) UNICODE UPPERCASE | X(128) | UDT Name when the element data type of an ARRAY type column is UDT. |
| PartitioningColumn | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies N if not a partitioning column and Y if a partitioning column in a partitioning expression. |
| ColumnPartitionNumber | BIGINT NOT NULL | -(19)9 | Specifies 0 if not column partitioned. |
| ColumnPartitionFormat | CHAR(2) LATIN UPPERCASE NOT NULL | X(2) | Specifies NA if not applicable (that is, not column partitioned). First character:
Second character:
|
| ColumnPartitionAC | CHAR(2) LATIN UPPERCASE NOT NULL | X(2) | Specifies NA if not applicable (that is, not column partitioned), NC if no auto compress, and AC if auto compress. |
| PseudoUDTFieldId | SMALLINT | ---,--9 | 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) | Indicates 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) | 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 | The inline length of a UDT. |
| TSColumnType | CHAR(2) LATIN UPPERCASE | X(2) | 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) | Indicates if a column is an AUTO COLUMN. |
| RowVersionNo | SMALLINT | ---,--9 | The row version number. |