where slug store in wordpress

The slug for Posts and Pages are stored in the wp_posts posts table in the column post_name. Just be aware that all the automatic saves as well as attachments are stored in the same table, so there will not be a solid column full of slugs, but only one for each “parent” (parent to the revisions) Post or Page.