Category: Integrity
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
DatabaseName | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | Returns the name of the database containing a table with a column-level check. |
TableName | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | Returns the name of a table having column-level check constraints. |
ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the column name having column-level checks. |
ColCheck | VARCHAR(8192) UNICODE NOT CASESPECIFIC | X(8192) | Returns the unresolved text for the column-level check condition. |
CreatorName | VARCHAR(128) UNICODE UPPERCASE 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. |
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. |