How many tables are there in WordPress by default?

by

At present version, there are about 11 tables in WordPress by default. You can check the number of tables in WordPress by phpMyAdmin.

  • wp_commentmeta
  • wp_comments
  • wp_links
  • wp_options
  • wp_postmeta
  • wp_posts
  • wp_terms
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_usermeta
  • wp_users

Note: The number of tables may be changed with successive releases.

In WordPress, there are typically 12 default tables created in the WordPress database when you install the platform. These tables are:

  1. wp_users
  2. wp_usermeta
  3. wp_posts
  4. wp_postmeta
  5. wp_comments
  6. wp_commentmeta
  7. wp_terms
  8. wp_term_taxonomy
  9. wp_term_relationships
  10. wp_options
  11. wp_links
  12. wp_post_formats (introduced in WordPress 3.1)

These tables store various types of data such as user information, posts, comments, terms (categories and tags), options/settings, and more, forming the backbone of WordPress functionality.