MySQL: Show or List Tables

Profile picture for user arilio666

We can able to show or list tables in, MySQL using the SHOW clause in MySQL querying using this will reportedly list the thing you wanna see or represent within the database.

This query can be called after reaching inside the database or from outside using the database name of our wish to list the tables.

Let us see some of the things that SHOW can do in real-time action.

Syntax

USE DataBase;
SHOW tables;

or

SHOW tables in DataBase;

or

SHOW tables FROM DataBase;

These are some of the ways that you can show/list tables in MySQL.

Example

use sql_inventory;
show tables;

show tables in sql_store;

show tables FROM sql_hr;

All these following queries return or represent the list of tables when called matching to their respective database name or use the DB and list them.

Tags