- SQL Basics
- SQL Introduction
- SQL Syntax
- SQL Sample Database
- SQL SELECT
- SQL WHERE
- SQL ORDER BY
- SQL DISTINCT
- SQL LIMIT
- SQL FETCH
- SQL AND
- SQL OR
- SQL BETWEEN
- SQL IN
- SQL LIKE
- SQL IS NULL
- SQL Comparison Operators
- SQL Logical Operators
- SQL Alias
- SQL CASE
- Joins and Subqueries
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL OUTER JOIN
- SQL SELF JOIN
- SQL CROSS JOIN
- SQL Subquery
- SQL Correlated Subquery
- SQL UNION
- SQL INTERSECT
- SQL EXCEPT
- Aggregate Functions
- SQL AVG
- SQL COUNT
- SQL MAX
- SQL MIN
- SQL SUM
- SQL GROUP BY
- SQL HAVING
- SQL ROLLUP
- SQL CUBE
- SQL GROUPING SETS
- Database Management
- SQL CREATE DATABASE
- SQL ALTER DATABASE
- SQL DROP DATABASE
- SQL BACKUP DATABASE
- SQL SHOW DATABASES
- SQL SELECT DATABASE
- Table Management
- SQL CREATE TABLE
- SQL ALTER TABLE
- SQL ADD COLUMN
- SQL DROP COLUMN
- SQL DROP TABLE
- SQL TRUNCATE TABLE
- SQL SHOW TABLES
- SQL RENAME TABLE
- SQL Constraints
- SQL Primary Key
- SQL Foreign Key
- SQL UNIQUE Constraint
- SQL CHECK Constraint
- SQL NOT NULL Constraint
SQL SHOW TABLES
The SHOW TABLES statement is used to list all tables in the currently selected database.
Key Features of SQL SHOW TABLES
- Displays a list of tables present in the selected database.
- Helps verify the existence of tables before performing operations.
- Works in MySQL, MariaDB, and some other database systems.
SQL SHOW TABLES Syntax
SHOW TABLES;
Example: Listing All Tables
USE my_database;
SHOW TABLES;
- Selects the
my_databaseand displays all tables in it.
Example Output
| Tables_in_my_database |
|---|
| Employees |
| Departments |
| Projects |
Alternative Commands for Other Databases
Summary
SHOW TABLESlists all tables in the current database.- Works mainly in MySQL and MariaDB.
- Use alternative queries for PostgreSQL, SQL Server, and Oracle.