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