Grimoire-
Command
.es

GNU+Linux command memo

List database tables

Lister les tables d’une base de donnée

MySQL / MariaDB
$ mysql -p show tables;
PostgreSQL
\dtvs (1)
SELECT table_name FROM pg_database; (1)
1 equivalent

 

SQLite3
SELECT table_name FROM sqlite_master WHERE type='table';