Reference Guide > TDV and Business Directory System Tables > ALL_CATALOGS
 
ALL_CATALOGS
The ALL_CATALOGS system table exposes all published catalogs to which the current user has access. Users can see catalogs for which they have at least one privilege.
Column
TDV
JDBC Data Type
Nullable
Description
CATALOG_ID
INTEGER
 
Identifier of the catalog. Primary key.
CATALOG_NAME
VARCHAR(255)
 
Name of the catalog.
DATASOURCE_ID
INTEGER
 
Identifier of the data source.
DATASOURCE_NAME
VARCHAR(255)
 
Name of the data source.
BD_DATASOURCE_NAME
VARCHAR(255)
 
BD name of the data source.
GUID
VARCHAR(36)
 
Nearly unique 128-bit identifier.
ANNOTATION
VARCHAR(36)
Yes
Annotation for the catalog.
OWNER_ID
INTEGER
 
Identifier of the user who created or owns the catalog.
OWNER
VARCHAR(255)
 
User name of the user who created or owns the catalog.
PARENT_PATH
VARCHAR(255)
 
Path to the parent container.
BD_PARENT_PATH
VARCHAR(255)
 
BD path to the parent container.