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. |