MySQL SHOW TABLES Command

This command is used to display a list of all tables in a specific database in MySQL; you can use the following command after selecting the database:

Syntax

The general syntax of the command is as follows:

SHOW TABLES;

First, you need to select the database you want to work with using the USE command.

Example

For example, To list the tables in the world database

USE world;

and then issue

SHOW TABLES;

Video Tutorial

 

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

• https://www.mysql.com/