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