WordPress.org
Get WordPress
WordPress.org

WordPress Developer Resources

wp db tables

wp db tables

Lists the database tables.

In this article

Back to top

GitHub
View Open Issues (0) View Closed Issues (16) Create New Issue
Defaults to all tables registered to the $wpdb database handler.

Options

See the argument syntax reference for a detailed explanation of the syntax conventions used.
[<table>…]
List tables based on wildcard search, e.g. ‘wp_*_options’ or ‘wp_post?’.
[–scope=<scope>]
List tables based on the scope.
  • all: returns ‘all’ and ‘global’ tables. No old tables are returned.
  • blog: returns the blog-level tables for the queried blog.
  • global: returns the global tables for the installation, returning multisite tables only on multisite.
  • ms_global: returns the multisite global tables, regardless if current installation is multisite.
  • old: returns tables which are deprecated. — default: all options:
    • all
    • blog
    • global
    • ms_global
    • old —
[–network]
List all the tables in a multisite install.
[–all-tables-with-prefix]
List all tables that match the table prefix even if not registered on $wpdb. Overrides –network.
[–all-tables]
List all tables in the database, regardless of the prefix, and even if not registered on $wpdb. Overrides –all-tables-with-prefix.
[–format=<format>]
Render output in a particular format. — default: list options: – list – csv —

Examples

# List tables for a single site, without shared tables like 'wp_users'
$ wp db tables --scope=blog --url=sub.example.com
wp_3_posts
wp_3_comments
wp_3_options
wp_3_postmeta
wp_3_terms
wp_3_term_taxonomy
wp_3_term_relationships
wp_3_termmeta
wp_3_commentmeta

# Export only tables for a single site
$ wp db export --tables=$(wp db tables --url=sub.example.com --format=csv)
Success: Exported to wordpress_dbase.sql

Global Parameters

These global parameters have the same behavior across all commands and affect how WP-CLI interacts with WordPress.
Argument Description
--path=<path> Path to the WordPress files.
--url=<url> Pretend request came from given URL. In multisite, this argument is how the target site is specified.
--ssh=[<scheme>:][<user>@]<host\|container>[:<port>][<path>] Perform operation against a remote server over SSH (or a container using scheme of “docker”, “docker-compose”, “docker-compose-run”, “vagrant”).
--ssh-args=<args> Pass additional arguments to SSH (or other tools specified by –ssh scheme).
--http=<http> Perform operation against a remote WordPress installation over HTTP.
--user=<id\|login\|email> Set the WordPress user.
--skip-plugins[=<plugins>] Skip loading all plugins, or a comma-separated list of plugins. Note: mu-plugins are still loaded.
--skip-themes[=<themes>] Skip loading all themes, or a comma-separated list of themes.
--skip-packages Skip loading all installed packages.
--require=<path> Load PHP file before running the command (may be used more than once).
--exec=<php-code> Execute PHP code before running the command (may be used more than once).
--context=<context> Load WordPress in a given context.
--[no-]color Whether to colorize the output.
--debug[=<group>] Show all PHP errors and add verbosity to WP-CLI output. Built-in groups include: bootstrap, commandfactory, and help.
--prompt[=<assoc>] Prompt the user to enter values for all command arguments, or a subset specified as comma-separated values.
--quiet Suppress informational messages.
--alias=<name> Name of the alias to use. Aliases can reference local WordPress installations or remote SSH connections. Aliases are defined in the wp-cli.yml file.
--assume-https Set $_SERVER[‘HTTPS’] to make WordPress treat the site as HTTPS. Use when WordPress is behind an HTTPS proxy or load balancer.

Command documentation is regenerated at every release. To add or update an example, please submit a pull request against the corresponding part of the codebase.