show tables (example)

show tables

MariaDB [your_database]> show tables;
+-------------------------+
| Tables_in_your_database |
+-------------------------+
| actor                   |
| archive                 |
| bot_passwords           |
| category                |
| categorylinks           |
| change_tag              |
| change_tag_def          |
| comment                 |
| content                 |
| content_models          |
| externallinks           |
| filearchive             |
| image                   |
| imagelinks              |
| interwiki               |
| ip_changes              |
| ipblocks                |
| ipblocks_restrictions   |
| iwlinks                 |
| job                     |
| l10n_cache              |
| langlinks               |
| log_search              |
| logging                 |
| module_deps             |
| objectcache             |
| oldimage                |
| page                    |
| page_props              |
| page_restrictions       |
| pagelinks               |
| protected_titles        |
| querycache              |
| querycache_info         |
| querycachetwo           |
| recentchanges           |
| redirect                |
| revision                |
| revision_actor_temp     |
| revision_comment_temp   |
| searchindex             |
| site_identifiers        |
| site_stats              |
| sites                   |
| slot_roles              |
| slots                   |
| templatelinks           |
| text                    |
| updatelog               |
| uploadstash             |
| user                    |
| user_former_groups      |
| user_groups             |
| user_newtalk            |
| user_properties         |
| watchlist               |
+-------------------------+
56 rows in set (0.00 sec)

See also

• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint
• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306