What columns stores the slug in wordpress

Question

In wordpress, what column stores the slug (either auto generated, or user entered)?

I can not find this in either wp_posts or wp_postmeta. The wp_posts GUID stores a direct link, but not the slug.

Answer 1

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.

Answer 2

This might help: How WordPress Post Slugs Work