Get table names using SELECT statement in MySQL?

To get table names using SELECT statement, use “information_schema.tables”. Let us see an example, wherein we have a database that contains 3 tables. The syntax to get all table names with the help of SELECT statement.

SELECT Table_name as TablesName from information_schema.tables where table_schema = 'yourDatabaseName';

Using database “test”, and applying the above syntax to get the table names using SELECT

mysql> use test;
Database changed
mysql> SELECT Table_name as TablesName from information_schema.tables where table_schema = 'test';

Output with the name of the three tables.

+--------------------+
| TablesName         |
+--------------------+
| destination        |
| myisamtoinnodbdemo |
| originaltable      |
+--------------------+
3 rows in set (0.00 sec)

Chandu yadav

Published on 29-Nov-2018 05:54:44

• Related Questions & Answers
• Get table column names in alphabetical order in MySQL?
• MySQL case statement inside a select statement?
• MySQL Quoted table/field names vs unquoted names?
• Select Statement to retrieve the same first names with similar last name (but different case) using MySQL?
• Lower case column names with MySQL SELECT?
• How to get all table names from a database using JDBC?
• Select column names containing a string in MySQL?
• MySQL SELECT IF statement with OR?
• How to create a temporary MySQL table in a SELECT statement without a separate CREATE TABLE?
• How to can I get the names of my MySQL table columns?
• IF() function in a MySQL Select statement?
• How to call a stored procedure using select statement in MySQL?
• Explain the use of SELECT DISTINCT statement in MySQL using Python?
• MySQL Select Statement DISTINCT for Multiple Columns?
• What is the syntax in MySQL to get the column names of a table?