SHOW TABLES

SafeList tables

SHOW TABLES;

Lists tables in the current database; PostgreSQL uses \dt.

Examples

SHOW TABLES;Show tables

Syntax

SHOW TABLES; (PG) \dt

Before you run it

Read-only.

Related commands

DESCRIBEDescribe a table
SELECTRead data

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store