The examples were created with the MyWAY SQL manager: Download
How to use the SCHEMA() function in MySQL and MariaDB databases
The SCHEMA() function in MySQL and MariaDB is used to retrieve the name of the currently used database. The function can be used directly in a SQL statement or within a SQL query, requires no arguments, and returns a string representing the name of the current database.
The SCHEMA() function can be used to get the current database name within a query or procedure, for example to switch between databases or to reference objects in the current database. The function can be used to organize queries or statements based on the current database, for example, different queries can be executed or different logic can be applied depending on the database context. When creating dynamic SQL statements, the function is useful to include the current database name in the generated SQL code, allowing for more flexible and dynamic queries that adapt to the current database context.
