Catalog-Specific Functions and Variables

Documents the catalog() function, which returns the current catalog name, and the @@catalogs system variable, which indicates if the server is configured for catalogs.

circle-info

Catalogs are planned for an upcoming release, and don't yet appear in any current releases.

Catalog Functions

catalog()

`catalog()

returns the name of the current catalog.`

MariaDB [def.test]> select catalog();
+-----------+
| catalog() |
+-----------+
| def       |
+-----------+

Catalog Variables

@@catalogs

One can check if a server supports catalogs with:

SELECT @@catalogs;
+------------+
| @@catalogs |
+------------+
|          1 |
+------------+

1 means that the server is configured for catalogs.

This page is licensed: CC BY-SA / Gnu FDL

spinner

Last updated

Was this helpful?