Are custom posts delete by unregistering post type

By running unregister_post_type() custom posts are not deleted from database even they can be retrieved by custom query. They mustn’t be appear in regular post loop since their post_type remain what was.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)