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)