SYSADMIN.VirtualSchemas

このテーブルは、仮想スキーマに関する情報を提供します。

Column Name

Type

Description

id

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

このテーブルは、ビュー定義に関する情報を提供します。

Column Name

Type

Description

name

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

このテーブルは、プロシージャ定義に関する情報を提供します。

Column Name

Type

Description

name

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

このテーブルは、関数定義に関する情報を提供します。

Column Name

Type

Description

name

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