Application Programming Interface Guide > DSL API > SQL Script Procedures > System Tables
 
System Tables
The following system tables under /services/databases/system/model directory, store the information about datasources:
ALL_PROCEDURES
The system table model.ALL_PROCEDURES table is updated with procedure information and has the following columns.
This table is similar to system.ALL_PROCEDURES table, however, this table contains information about both published and non-published procedures.
Column name
TDV JDBC Data Type
Nullable
Description
PROCEDURE_ID:
INTEGER
 
Identifier of the procedure; Primary key.
PROCEDURE_NAME:
VARCHAR
 
Name of the procedure
PROCEDURE_TYPE:
SMALLINT
 
Type of the procedure
1 indicates procedure returns no result
2 indicates procedure returns result
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_ID 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
 
Annotation for the procedure
OWNER_ID:
INTEGER
 
Identifier of the person who created/owns the procedure. Same as USER_ID in Table: ALL_USERS
OWNER:
VARCHAR
 
User name of the person who created/owns the procedureSame as USERNAME in Table: ALL_USERS
PARENT_PATH:
VARCHAR
 
Path to the parent container.
IS_AUTO_GENERATED
VARCHAR
 
Indicates if the parent folder has an attribute called 'webui_model'. If attribute is present, the value is 'YES' else 'NO'
PROCEDURE_CREATOR_ID:
INTEGER
 
Identifier of the user who created this procedure. Same as USER_ID in Table: ALL_USERS
PROCEDURE_CREATION_TIMESTAMP:
BIGINT
 
Timestamp when the procedure was created.
PROCEDURE_MODIFIER_ID:
INTEGER
 
Identifier of the user who last modified this procedure. Same as USER_ID in Table: ALL_USERS
PROCEDURE_MODIFICATION_TIMESTAMP:
BIGINT
 
Timestamp of the last modification of this procedure.
IMPACT_MESSAGE
VARCHAR
 
Impact message indicating errors.