I wanted to delete DotNetNuke related tables from my database, which were created during accidental instalation of DotNetNuke(I accidentally provide connection to the wrong database). I decided to use UnInstall.SqlDataProvider script file from Providers\DataProviders\SqlDataProvider DNN 4.0.2 installation.
However there were a lot of errors when running the script.
There were also a few objects that I had to delete manually using Enterprise Manager (They probably were created by individual modules). Additionally I had to delete ASPNET_ membership tables and SPs.
List of errors and additional SQL commands I've posted here.