See this article: http://codex.buddypress.org/buddypress-site-administration/deleting-buddypress/ Refer to the article but the bottom line is delete any table with the WP_BP prefix.