WordPress Database Tables

The following database tables belong to the WordPress core.

  • commentmeta
    Stores metadata for comments (e.g., extra info about a comment).
  • comments
    Stores user and guest comments on posts.
  • links
    Stores blogroll links (deprecated, rarely used).
  • options
    Stores site-wide settings and configuration options.
  • postmeta
    Stores metadata for posts (e.g., custom fields).
  • posts
    Stores all post types, including pages, attachments, and custom post types.
  • termmeta
    Stores metadata for taxonomy terms (e.g., categories, tags).
  • terms
    Stores individual taxonomy terms (e.g., category names, tag names).
  • term_relationships
    Links posts to terms (e.g., which posts belong to which category).
  • term_taxonomy
    Defines the taxonomy type for each term (e.g., category or tag).
  • usermeta
    Stores metadata for users (e.g., custom user settings).
  • users
    Stores user account details (e.g., username, email, password hash).

The default WordPress database prefix is wp_.

For more WordPress database prefixes visit our plugin database.

Article written by

Last updated