MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 
Home / Database Structure / Question No: 133

How to get all existing tables in the MySQL database?

I need to know about all existing tables in MySQL database. Is there any command in the MySQL that may help me to show all existing tables in my database?

Answer No: 133

You can get all existing tables by MySQL SHOW TABLES statement. Run this statement using any MySQL client like phpMyAdmin etc and get all existing tables. Take an example, this will show you all existing tables in the current database:

SHOW TABLES;

If you want to get existing tables of another database instead of current database, take the following example. This will show you all tables of named database.

SHOW TABLES FROM database_name;

Related MySQL FAQs to the Above FAQ

How-to-create-database How to create database?

How-to-alter-or-drop-a-database How to alter or drop a database?

How-to-get-database-metadata-in-MySQL How to get database metadata in MySQL?

How-to-rename-existing-database-in-MySQL How to rename existing database in MySQL?

What-is-limit-on-the-maximum-number-of-tables-allowed-in-MySQL What is limit on the maximum number of tables allowed in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.