SYSADMIN.VirtualSchemas
このテーブルは、仮想スキーマに関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| biginteger | Virtual schema ID |
| string | Virtual schema name |
| boolean | Flag to signal whether virtual schema can be deleted or not |
| timestamp | Timestamp when the virtual schema was created |
| timestamp | Timestamp when the virtual schema was last modified |
| string | Name of the user who created the schema |
| string | Name of the user who last modified the schema |
SYSADMIN.ViewDefinitions
このテーブルは、ビュー定義に関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| string | View name |
| string | SQL script defining how to create the view |
| timestamp | Timestamp when the view was created |
| timestamp | Timestamp when the view was last modified |
| string | State of the view (e.g. |
| string | Reason why the view has |
| boolean | Flag to signal whether the view is in sync with the source tables or not |
| string | Reason why a view is not in sync with the source |
| string | Name of the user who created the view definition |
| string | Name of the user who last modified the view definition |
SYSADMIN.ProcDefinitions
このテーブルは、プロシージャ定義に関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| string | Procedure name |
| string | SQL script defining how to create the procedure |
| timestamp | Timestamp when the procedure was created |
| timestamp | Timestamp when the procedure was last modified |
| string | State of the procedure (e.g. |
| string | Reason why the procedure has |
| string | Name of the user who created the procedure |
| string | Name of the user who last modified the procedure |
SYSADMIN.FunctionDefinitions
このテーブルは、関数定義に関する情報を提供します。
Column Name | Type | Description |
---|---|---|
| string | Function name |
| string | SQL script defining how to create the function |
| timestamp | Timestamp when the function was created |
| timestamp | Timestamp when the function was last modified |
| string | State of the function (e.g. |
| string | Reason why the function has |
| string | Name of the user who created the function |
| string | Name of the user who last modified the function |
SYSADMIN.FunctionDefinitions
is available since v4.8