
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
While connecting to one MySQL database, how can I see the list of tables of other MySQL 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)
- Related Articles
- How to get the list of tables in default MySQL database?
- How Can I check the size of the tables in a particular MySQL database?
- How can we see the list of views stored in a particular MySQL database?
- How can we see MySQL temporary tables in the list of tables?
- How can I check the tables of databases other than current database?
- How can we see the list, along with some other information, of stored functions in a particular MySQL database?
- How can we see the list, along with other information, stored procedures in a particular MySQL database?
- How can we see only the list of stored procedures in a particular MySQL database?
- How can we see only the list of stored functions in a particular MySQL database?
- List down all the Tables in a MySQL Database
- Connecting to a MySQL database with Java
- Connecting to MySQL database from the command line?
- How can I see the description of a MySQL Temporary Tables?
- How to get the size of the tables of a MySQL database?
- How to count the number of tables in a MySQL database?

Advertisements