SHOW CREATE DATABASE
Provides the CREATE DATABASE statement needed to recreate the given database with its current specification.
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the SHOW CREATE DATABASE page in the MariaDB Enterprise Documentation.