CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Schemata View
 
Schemata View
Describes the catalog schemas.
This view is part of the ANSI SQL-2 standard information schema.
Column
Data Type
N
Description
RECORD_NUMBER
integer
n
unique identifier for this record of metadata
CATALOG_NAME
identifier
n
schema catalog
SCHEMA_NAME
identifier
n
schema name
SCHEMA_OWNER
identifier
n
schema owner
DEFAULT_CHARACTER_SET_CATALOG
identifier
n
default character set for catalog (currently unused)
DEFAULT_CHARACTER_SET_SCHEMA
identifier
n
default character set for schema (currently unused)
DEFAULT_CHARACTER_SET_NAME
identifier
n
default character set for name (currently unused)