/
USE

USE

Owned by Boaz Raufman
Feb 26, 2019

Sets the current active schema.

Syntax

USE schema_name

Description

The Schema remains active until the end of the session, or until another use statement is issued.

Example

> SHOW SCHEMAS;

SCHEMA NAME
-----------------------
def_schema
new_schema
-----------------------
Total query time: 0.021219

Rows count: 2

> use new_schema;

See Also

SHOW SCHEMAS

CREATE SCHEMA

CURRENT_DATABASES

Related content