How can I check the tables of databases other than current database?

With the help of following MySQL command, we can check the tables of a database other than the database we are currently using −

Show Tables from Database_name;

For example, the following query would display the list of tables from a database named ‘gaurav’ when currently we are using a database named ‘new’ −

mysql> use new;
Database changed

mysql> show tables from gaurav;
+--------------------+
| Tables_in_tutorial |
+--------------------+
| testing            |
| employee           |
| tender             |
| Ratelist           |
+--------------------+
4 rows in set (0.00 sec)

Giri Raju

Published on 22-Feb-2018 07:33:31

• Related Questions & Answers
• While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
• How Can I check the size of the tables in a particular MySQL database?
• How can I display all databases in MySQL and for each database show all tables?
• How can I check the list of MySQL tables, in the current database we are using, along with table type in the result set?
• How can I get the list of columns from a table in the other database than we are currently using?
• How can I freeze all tables in SAP HANA database?
• How can I check the list of MySQL tables, in a different database than we are using currently, along with table type in the result set?
• How can I check the character set of all the tables along with column names in a particular MySQL database?
• How can I get the list of columns from a table in the other database than we are currently using IN operator?
• Are there any other ways I can improve my concentration other than the Rubic Cube?
• How can we check the character set of all the tables in a particular MySQL database?
• How can I check MySQL tables from a database in accordance with particular column/s name?
• How can we get only the name having no other details about the tables in MySQL database?
• How can I check the list of MySQL tables, in a different database than we are using currently, along with table type in the result set using IN operator?
• How can I describe all tables in the database through a single statement in MySQL?