SCHEMATA

This view contains information about schemas (databases).

Column Name

Description

CATALOG_NAME

The name of the related catalog for a given database.

SCHEMA_NAME

The name of a given database.

DEFAULT_CHARACTER_SET_NAME

The name of the default character set for a given database.

DEFAULT_COLLATION_NAME

The name of the default collation for a given database.

SQL_PATH

This value is always NULL.

Last modified: August 29, 2022

Was this article helpful?