BroadSQLOn this page
SET SCHEMA
Core command
SE SC
SESC
Changes the current schema of the connection.
Syntax
SET SCHEMA <schema>Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
<schema> | Yes | An existing schema of the current connection, in any case | None |
Examples
SET SCHEMA INFORMATION_SCHEMA;Details
The schema must exist in the current connection; it is matched ignoring case. Afterwards, a table name without a schema refers to this schema, in SQL statements and in commands such as SHOW TABLES or DESCR, until the schema is changed again or the connection is closed.
Related
Last modified in release 5.5.0.
Found something wrong or unclear on this page? Tell us, with the page address.