Rename or Change Post Type Name Using SQL Statement

To rename or change a (custom) post type name, you can use the SQL statement below:

UPDATE  `wp_posts` SET  `post_type` =  '<new post type name>' WHERE  `post_type` = '<old post type name>';