What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?

As we know that with the help of SHOW DATABASES statement we can see the list of MySQL databases. Similarly, we can use SHOW SCHEMAS as the synonym of SHOW DATABASES to get the list of databases.

Example

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gaurav             |
| mysql              |
| performance_schema |
| query              |
| query1             |
| sys                |
| tutorials          |
+--------------------+
8 rows in set (0.07 sec)

mysql> SHOW SCHEMAS;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gaurav             |
| mysql              |
| performance_schema |
| query              |
| query1             |
| sys                |
| tutorials          |
+--------------------+
8 rows in set (0.00 sec)

Priya Pallavi

Updated on 10-Feb-2020 08:13:51

• Related Questions & Answers
• Which MySQL query can be used with the help of which we can see the list of MySQL databases?
• How can we display a list of currently existing MySQL databases on the server?
• Return list of databases in MySQL?
• What is the BSON query for the command 'show dbs' (list of databases) in MongoDB?
• What is the way to check the size of all the MySQL databases?
• How can we check the default character sets of all the MySQL databases we have on the server?
• What is the purpose of using MySQL CHAR_LENGTH() function? Which function is the synonym of it?
• Explain the importance of centralized databases
• How can we see MySQL temporary tables in the list of tables?
• Get a list of MySQL databases and version?
• How can we get the list of MySQL server-side help categories?
• How can we filter data with the help of MySQL subquery?
• Types of databases
• How to get the list of all databases using JDBC?
• How to get the list of all the MongoDB databases using java?