USE Statement#

The USE statement sets the current catalog and namespace.

Examples#

Set the session's current_catalog to my_catalog.

1

USE my_catalog;

Set the session's current_catalog to my_catalog, and current_namespace to my_namespace.

1

USE my_catalog.my_namespace;

Rules#

1. If the catalog does not exist, this will raise an error.
2. If no namespace is given, then current_namespace is set to NULL.

Syntax#

1
2
3
4
5
6
7
8
9

use_statement
    'USE' catalog_ident
    'USE' catalog_ident '.' namespace_ident

catalog_ident
    simple_ident

namespace_ident
    ident