List all tables SQL

?
S
Bash

Quick reference for SQL command to retrieve all table names in a database. Useful for database exploration and schema analysis.

1SELECT table_name
2  FROM information_schema.tables
3 WHERE table_schema='public'
4   AND table_type='BASE TABLE';

Created on 3/17/2021