WordPress database tablesFrom sources across the web
Wp_commentmeta
Wp_comments
Wp_links
Wp_options
Wp_postmeta
Wp_posts
Wp_term_relationships
Wp_term_taxonomy
Wp_termmeta
Wp_terms
Wp_usermeta
Wp_users
WordPress Default Database Tables
| Table Name | Description |
|---|---|
wp_posts | Stores all content types — posts, pages, custom post types (products, attachments, etc.). |
wp_postmeta | Stores custom fields (metadata) for posts and pages. |
wp_users | Stores user account information (username, password, email). |
wp_usermeta | Stores metadata (roles, capabilities) about users. |
wp_terms | Stores individual terms (categories, tags, custom taxonomies). |
wp_term_taxonomy | Defines whether a term is a category, tag, or custom taxonomy. |
wp_term_relationships | Links posts to their categories, tags, or custom taxonomies. |
wp_options | Stores site settings, theme options, plugin settings, etc. |
wp_comments | Stores comments left by users. |
wp_commentmeta | Stores metadata for comments. |
wp_links | Legacy table for blogrolls; rarely used today. |