Pratik Gujarathi
Reputation: 768
How to retrieve table names from database in mysql?
I want to retrieve table names from the database. I am using the phpmyadmin database. What query should be used?
Upvotes: 2
Views: 178
Answers (1)
codaddict
Reputation: 454930
You can make use of MySQL show tables as:
SHOW TABLES FROM db_name
Output of SHOW TABLES contains a single column of table names.
Upvotes: 4
Related Questions
- How to display all table names from particular mysql database in php
- Get table names using SELECT statement in MySQL
- How to get the list of table names from database in Drupal
- Using PHP to return table names
- Displaying all table names in php from MySQL database
- Grab Table Name From MySQL Database Using PHP
- Get table names from a database
- How to retrieve all table names from database?
- How can i read the table name while showing tables from database php mysql
- Table name list from My SQL database