Category: Database
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
IndexID | SMALLINT NOT NULL | ---,--9 | Returns the reference index number. Note: This is not the same as IndexNumber. |
IndexName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the reference index. |
ParentDB | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the referenced database. |
ParentTable | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the referenced table. |
ParentKeyColumn | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the column in a referenced key. |
ChildDB | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the referencing database. |
ChildTable | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the referencing table. |
ChildKeyColumn | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of a column in the referencing key. |
InconsistencyFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Inconsistencies allowed between related parent-child object definitions after restore: Y (yes), N (no). |
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. |