Reference Guide > TDV and Business Directory System Tables > ALL_TABLES
 
ALL_TABLES
The ALL_TABLES system table exposes all published tables to which the current user has access. Users can see tables for which they have at least one privilege.
Column
TDV
JDBC Data Type
Nullable
Description
TABLE_ID
INTEGER
 
Identifier of the table. Primary key.
TABLE_NAME
VARCHAR(255)
 
Name of the table.
TABLE_TYPE
VARCHAR(24)
 
Data type of the table.
BD_TABLE_TYPE
VARCHAR(24)
 
BD table type.
SCHEMA_ID
INTEGER
Yes
Identifier of the schema.
SCHEMA_NAME
VARCHAR(255)
Yes
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.
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. (CHAR in BD.)
ANNOTATION
VARCHAR(2147483647)
Yes
Annotation for the table.
OWNER_ID
INTEGER
 
Identifier of the person who created or owns the table.
OWNER
VARCHAR(255)
 
Name of the person who created or owns the table.
PARENT_PATH
VARCHAR(787)
 
Path to the parent container.
BD_PARENT_PATH
VARCHAR(787)
 
BD path to the parent container.
TABLE_CREATOR_ID
INTEGER
 
Identifier of the user who created this table. Same as USER_ID in ALL_USERS.
TABLE_
CREATION_TIMESTAMP
BIGINT
 
Timestamp when the table was created.
TABLE_MODIFIER_ID
INTEGER
 
Identifier of the user who last modified this table. Same as USER_ID in ALL_USERS.
TABLE_MODIFICATION_
TIMESTAMP
BIGINT
 
Timestamp when the table was modified.
LAST_MODIFICATION_
TIMESTAMP
BIGINT
 
Timestamp when the table was last modified.