How to see all tables in sql command line

---

---

There are several instances when you need to retrieve a list of tables from your database.

Sql query to list all tables in a schema

Update query in sql

Show table in mysql

Sql show table structure

Display table name in sql query

This could be done for testing purposes, to identify any existing tables before adding or removing any, or for any other reason. This tutorial will discuss how we can list down all the table in MySQL, SQL Server and Oracle using simple SQL commands.

MySQL - Listing Tables

You can use SQL SHOW TABLES statements in MySQL to list down all the tables available in a selected database.

Syntax

Following is the syntax to list all the tables in SQL in MySQL −

SHOW TABLES;

Example

Following is an example which will list down all the tables from a testDB database.

USE testDB; SHOW TABLES;

This will display the following output depending on the number of tables available in your database.

SQL Server - Listing Tables

SQL Server does not provide SHOW TABLE command in an SQL Server.

Instead, we can use the "SELECT" statement to retrieve information about tables in a database.

show create table query in sql server

show all tables query in sql