List MySQL Tables

Topic

How to List the MySQL Tables ?

Explanation

List MySQL Tables :


We can List Mysql tables using below structures.
  1. Desc Table.
  2. Show Table.

Desc table :


We can examine the structure of a table using the DESCRIPTION or DESC statement. The following query describes the structure of the student table.
List MySQL Tables
We can also use the SHOW FIELDS FROM statement to display the same structure.
mysql> SHOW FIELDS FROM student;

Listing Tables :


We can list all the tables in the database using SHOW TABLES query. The following query will list the tables in the current database.
List MySQL Tables