Application Programming Interface Guide > DSL API > Data Views > System Tables
 
System Tables
The following system tables under /services/databases/system/model directory, store the information about data sources:
ALL_TABLES
This table displays both the published and non-published tables and views. "VIEW" is displayed for TABLE_TYPE when the table is a view. The table model.ALL_TABLES table has the following columns :
Column name
TDV JDBC Data Type
Nullable
Description
TABLE_ID:
INTEGER
 
Primary key identifier of the table.
TABLE_NAME:
VARCHAR
 
Name of the table.
TABLE_TYPE:
VARCHAR
 
Possible values of this column are ‘VIEW’ and ‘TABLE”.
SCHEMA_ID:
INTEGER
Yes
See SCHEMA_ID in Table: model.ALL_SCHEMAS
SCHEMA_NAME:
VARCHAR
Yes
See SCHEMA_NAME in Table: model.ALL_SCHEMAS
CATALOG_ID:
INTEGER
Yes
See CATALOG_ID in Table: model.ALL_CATALOGS
CATALOG_NAME:
VARCHAR
Yes
See CATALOG_NAME in Table: model.ALL_CATALOGS
DATASOURCE_ID:
INTEGER
 
See DATASOURCE_ID in Table: model.ALL_DATASOURCES
DATASOURCE_NAME:
VARCHAR
 
See DATASOURCE_NAME in Table: model.ALL_DATASOURCES
GUID:
VARCHAR
 
128 bit unique identifier
ANNOTATION:
VARCHAR
Yes
Annotation for the table.
OWNER_ID:
INTEGER
 
Identifier of the person who created/owns the table. Same as USER_ID in Table: ALL_USERS
OWNER:
VARCHAR
 
Name of the person who created/owns the table. Same as USERNAME in Table: ALL_USERS
PARENT_PATH:
VARCHAR
 
Path to the parent container
TABLE_CREATOR_ID:
INTEGER
 
Identifier of the user who created this table. Same as USER_ID in Table: 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 Table: ALL_USERS
TABLE_MODIFICATION_TIMESTAMP:
BIGINT
 
Timestamp of the last modification of this table.
IMPACT_MESSAGE
VARCHAR
 
Impact message indicating errors
ALL_COLUMNS
When a data view is created, the columns of the view are added to the model.ALL_COLUMNS table.
Column name
TDV JDBC Data Type
Nullable
Description
COLUMN_ID:
INTEGER
 
Primary key identifier of the column
COLUMN_NAME:
VARCHAR
 
Name of the column
DATA_TYPE:
VARCHAR
 
String representation of the data type
ORDINAL_POSITION:
INTEGER
 
Position of this column in relation to other columns in the same table
JDBC_DATA_TYPE:
SMALLINT
 
JDBC/ODBC data types. For JDBC data types, see http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html
COLUMN_LENGTH:
INTEGER
 
If it is a CHAR or VARCHAR, the length is the maximum length allowed. If it is a DECIMAL or NUMERIC, then the value is the total number of digits. If it is none of the above types, then the value is NULL.
COLUMN_PRECISION:
INTEGER
 
If it is a DECIMAL or NUMERIC data type, then it is the number of digits. If it is not a DECIMAL or NUMERIC data type, then the value is NULL.
COLUMN_SCALE:
INTEGER
 
 
COLUMN_RADIX:
INTEGER
 
10 for all numeric data types. Null for all non-numeric types.
NULLABLE:
SMALLINT
 
Indicates whether the column is nullable
0 if NULL is not allowed
1 if NULL is allowed
2 if it is unknown
IS_NULLABLE:
VARCHAR
 
Indicates whether the column is nullable
YES if it is nullable
NO if it is not nullable
Blank string is returned if value is not known
TABLE_ID:
INTEGER
 
See TABLE_ID in Table: model.ALL_TABLES
TABLE_NAME:
VARCHAR
 
See TABLE_NAME in Table: model.ALL_TABLES
SCHEMA_ID:
INTEGER
Yes
See SCHEMA_ID in Table: model.ALL_SCHEMAS
SCHEMA_NAME:
VARCHAR
Yes
See SCHEMA_NAME in Table: model.ALL_SCHEMAS
CATALOG_ID:
INTEGER
Yes
See CATALOG_ID in Table: model.ALL_CATALOGS
CATALOG_NAME:
VARCHAR
 
See CATALOG_NAME in Table: model.ALL_CATALOGS
DATASOURCE_ID:
INTEGER
 
See DATASOURCE_ID in Table: model.ALL_DATASOURCES
DATASOURCE_NAME:
VARCHAR
 
See DATASOURCE_NAME in Table: model.ALL_DATASOURCES
ANNOTATION:
VARCHAR
Yes
Annotation for the column
OWNER_ID:
INTEGER
 
Identifier for the user who created/owns the column. Same as USER_ID in Table: ALL_USERS
OWNER:
VARCHAR
 
User name of the person that owns/created the data source. Same as USERNAME in Table: ALL_USERS
PARENT_PATH:
VARCHAR
 
Path to the parent container.