show tables (example)

From wikieduonline
Jump to navigation Jump to search

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[edit]

Advertising: