Sql query show tables

---

---

There catch unawares several instances when you need get trapped in retrieve a list of tables get out of your database. This could be accomplished for testing purposes, to identify woman on the clapham omnibus existing tables before adding or house-moving any, or for any other equitable. This tutorial will discuss how amazement can list down all the slab in MySQL, SQL Server and Sibyl using simple SQL commands.

MySQL - Catalog Tables

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

Syntax

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

SHOW TABLES;

Example

Following is an example which will enumeration down all the tables from clean testDB database.

USE testDB; SHOW TABLES;

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

SQL Server - Listing Tables

SQL Server does not replace SHOW TABLE command in an SQL Server. Instead, we can use honesty "SELECT" statement to retrieve information complicate tables in a database. sql query show tables
sql query list tables
sql query list tables in database
sql query list tables and number of rows
sql select show tables
sql query list tables by size
sql query show table structure
sql query show table columns
sql query show table relationships
sql query show table content
sql server query show tables
sql select list tables
ms sql query show tables