What is the database table for pages?

Question

When I go through the database of a fresh Wordpress 4 install I find, for example:

wp_posts
wp_terms
wp_users

Yet I didn't find `wp_pages'. Where is it?

Answer 1

the wp_posts include all post types (post, page, custom post..), and to differentiate between them there is a field called post_type used to specify the name of the current entry whether it's a page, post or a custom post.

Query below will get list of pages

SELECT * FROM wp_posts where post_type = 'page';

Answer 2

I entered to wp_posts and it seems all pages are inside there.