While connecting to one MySQL database, how can I see the list of tables of other MySQL database?

MySQL MySQLi Database

With the help of SHOW TABLES From Database_name query, we can see the tables of another database. Here Database_name is the name of the database which we are not using currently. Consider the following example in which we run the query for getting the list of tables in database name ‘tutorial’.

mysql> show tables from tutorial;
+--------------------+
| Tables_in_tutorial |
+--------------------+
| employee           |
| showzerofill       |
| student            |
+--------------------+
3 rows in set (0.00 sec)

seetha

Updated on: 13-Feb-2020

93 Views

Kickstart Your Career

Get certified by completing the course

Get Started