## MD_CATALOGS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS
--- | --- | --- | --- | --- | --- | ---
ID | NUMBER | No | null | 1 | 1 | null
CONNECTION_ID_FK | NUMBER | No | null | 2 | null | Foreign key into the connections table - Shows what connection this catalog belongs to //PARENTFIELD
CATALOG_NAME | VARCHAR2(4000 BYTE) | Yes | null | 3 | null | Name of the catalog //OBJECTNAME
DUMMY_FLAG | CHAR(1 BYTE) | Yes | 'N' | 4 | null | Flag to show if this catalog is a "dummy" catalog which is used as a placeholder for those platforms that do not support catalogs. 'N' signifies that this is NOT a dummy catalog, while 'Y' signifies that it is.
NATIVE_SQL | CLOB | Yes | null | 5 | null | THe SQL used to create this catalog
NATIVE_KEY | VARCHAR2(4000 BYTE) | Yes | null | 6 | null | A unique identifier used to identify the catalog at source.
COMMENTS | VARCHAR2(4000 BYTE) | Yes | null | 7 | null | null
SECURITY_GROUP_ID | NUMBER | No | 0 | 8 | null | null
CREATED_ON | DATE | No | sysdate | 9 | null | null
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 10 | null | null
LAST_UPDATED_ON | DATE | Yes | null | 11 | null | null
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 12 | null | null