Hitachi

Hitachi Advanced Database Setup and Operation Guide


B.8 Content of SQL_SCHEMATA

SQL_SCHEMATA stores schema-related definition information. Each row stores information for one schema.

The following table describes the content of SQL_SCHEMATA.

Table B‒10: Content of SQL_SCHEMATA

No.

Column name

Data type

Stored information

1

SCHEMA_OWNER

VARCHAR(100)

Schema owner

2

SCHEMA_DEFINER

VARCHAR(100)

Authorization identifier of the HADB user who defined the schema

3

SCHEMA_NAME

VARCHAR(100)

Schema name

4

CREATE_TIME

TIMESTAMP

Datetime stamp for when the schema was defined