Category: Integrity
Database: DBC
View Column | Data Type | Format | Description |
---|---|---|---|
DataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database containing a table with a table-level check. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a table having table-level check constraints. |
ConstraintName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of table-level check. NULL if unnamed. |
ConstraintText | VARCHAR(16000) UNICODE CASESPECIFIC | X(16000) | The unresolved text for the table-level check condition. |
CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Table or database creator. For DBC.AllRights, grantor of explicit rights, otherwise user who ran CREATE statement. |
CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time that the object in the row was created. |
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. |