Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


SCHEMATA


The SCHEMATA system view lists the schemas that are owned by the current ident.

Column name
Data type
Description
CATALOG_NAME
VARCHAR(128)
The name of the catalog containing the schema.
SCHEMA_NAME
VARCHAR(128)
The name of the schema.
SCHEMA_OWNER
VARCHAR(128)
The name of the ident who created the schema.
DEFAULT_CHARACTER_SET_CATALOG
VARCHAR(128)
The name of the catalog that contains the default character set for the schema.
DEFAULT_CHARACTER_SET_SCHEMA
VARCHAR(128)
The name of the schema that contains the default character set for the schema.
DEFAULT_CHARACTER_SET_NAME
VARCHAR(128)
The name of the default character set for the schema.
SQL_PATH
VARCHAR(2000)
The default path for the schema



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX