Virtual Schemas, Views, Procedures and Functions
SYSADMIN.VirtualSchemas
This table supplies information on virtual schemas.
Column Name | Type | Description |
|---|---|---|
| biginteger | Virtual schema ID |
name | string | Virtual schema name |
deletable | boolean | Flag to signal whether virtual schema can be deleted or not |
creationDate | timestamp | Timestamp when the virtual schema was created |
lastModifiedDate | timestamp | Timestamp when the virtual schema was last modified |
creator | string | Name of the user who created the schema |
modifier | string | Name of the user who last modified the schema |
SYSADMIN.ViewDefinitions
This table supplies information on view definitions.
Column Name | Type | Description |
|---|---|---|
| string | View name |
definition | string | SQL script defining how to create the view |
creationDate | timestamp | Timestamp when the view was created |
lastModifiedDate | timestamp | Timestamp when the view was last modified |
state | string | State of the view (e.g. READY, WARNING, FAILED) |
failureReason | string | Reason why the view has FAILED state |
inSyncWithSource | boolean | Flag to signal whether the view is in sync with the source tables or not |
notInSyncReason | string | Reason why a view is not in sync with the source |
creator | string | Name of the user who created the view definition |
modifier | string | Name of the user who last modified the view definition |
SYSADMIN.ProcDefinitions
This table supplies information on procedure definitions.
Column Name | Type | Description |
|---|---|---|
| string | Procedure name |
definition | string | SQL script defining how to create the procedure |
creationDate | timestamp | Timestamp when the procedure was created |
lastModifiedDate | timestamp | Timestamp when the procedure was last modified |
state | string | State of the procedure (e.g. READY, WARNING, FAILED) |
failureReason | string | Reason why the procedure has FAILED state |
creator | string | Name of the user who created the procedure |
modifier | string | Name of the user who last modified the procedure |
SYSADMIN.FunctionDefinitions
This table supplies information on function definitions.
Column Name | Type | Description |
|---|---|---|
| string | Function name |
definition | string | SQL script defining how to create the function |
creationDate | timestamp | Timestamp when the function was created |
lastModifiedDate | timestamp | Timestamp when the function was last modified |
state | string | State of the function (e.g. READY, WARNING, FAILED) |
failureReason | string | Reason why the function has FAILED state |
creator | string | Name of the user who created the function |
modifier | string | Name of the user who last modified the function |
SYSADMIN.FunctionDefinitions is available since v4.8