Reference Guide > TDV and Business Directory System Tables > ALL_DATASOURCES
 
ALL_DATASOURCES
The ALL_DATASOURCES system table exposes all published data sources to which the current user has access. Users can see those data sources for which they have at least one privilege.
Column
TDV
JDBC Data Type
Nullable
Description
DATASOURCE_ID
INTEGER
 
Identifier of the data source. Primary key.
DATASOURCE_NAME
VARCHAR(255)
 
Name of the data source.
BD_DATASOURCE_NAME
VARCHAR(255)
 
BD name of the data source.
DATASOURCE_TYPE
VARCHAR(255)
 
Data type of the data source. The number and variety of supported data source types are growing with each release.
GUID
VARCHAR(36)
 
Nearly unique 128-bit identifier.
ANNOTATION
VARCHAR(2147483647)
Yes
Annotation for the data source.
OWNER_ID
INTEGER
 
Identifier of the user who created or owns the data source.
OWNER
VARCHAR(255)
 
User name of the person that owns/created the data source.
PARENT_PATH
VARCHAR(2147483647)
 
Path to the parent container.
DATASOURCE_
CREATOR_ID
INTEGER
 
Identifier of the user who created this data source. Same as USER_ID in ALL_USERS table.
DATASOURCE_
CREATION_TIMESTAMP
BIGINT
 
Timestamp when the data source was created.
DATASOURCE_
MODIFIER_ID
INTEGER
 
Identifier of the user who last modified this data source. Same as USER_ID in ALL_USERS table.
DATASOURCE_
MODIFICATION_
TIMESTAMP
BIGINT
 
Timestamp of the last modification of this data source.