SCHEMA

Syntax

SCHEMA()

Purpose

SCHEMA() returns the name of the current schema. This function is a synonym of DATABASE().

Examples

Query the name of the current schema.

obclient> SELECT SCHEMA();
+----------+
| SCHEMA() |
+----------+
| test     |
+----------+
1 row in set