List MySQL Tables

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.
We can also use the SHOW FIELDS FROM statement to display the same structure.

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.