Hello Sarat1729,

Some time ago I wrote a sample of script in (MySQL syntax) that should do the majority of the steps that you want to do. MySQL and SQL the code is 90% - 95% the same minor modification would be needed. To avoid code duplication find sample of code here Re^7: extract column data.

If I understood correctly from your question you want to drop the table after retrieving the data, if this is the case you can simply do:

sub drop {
    my ($dbh, $table_name) = @_;
    my $quoted_name = $dbh->quote_identifier($table_name);
    $dbh->do("DROP TABLE $quoted_name");
}
[download]

The code has been copied from DBI "drop table" from the forum.

Hope this helps, BR.