SCHEMA

Declaration

SCHEMA()

Description

Returns the name of the current schema. This function is a synonym for DATABASE().

Examples

The following example queries the name of the current schema.

SELECT SCHEMA();
+----------+
| SCHEMA() |
+----------+
| test     |
+----------+
1 row in set (0.001 sec)