/
USE

USE

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

USE
More like this
DROP SCHEMA
DROP SCHEMA
More like this
CREATE SCHEMA
CREATE SCHEMA
More like this
ALTER SCHEMA
ALTER SCHEMA
More like this
SHOW
More like this
DROP SCHEDULED LOAD
DROP SCHEDULED LOAD
More like this