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