Drop every table in the database without requiring the DROP DATABASE permission.

drop_tables.rake

namespace :db do
  namespace :drop do
    desc "Drop every table in the database. (Does not require DROP DATABASE permission.)"
    task :tables => :load_config do
      config = ActiveRecord::Base.configurations[Rails.env || 'development']
      begin
        ActiveRecord::Base.establish_connection(config)
        puts "Dropping #{ActiveRecord::Base.connection.tables.count} tables."

        ActiveRecord::Base.connection.tables.each do |table|
          ActiveRecord::Base.connection.execute("DROP TABLE IF EXISTS #{table}")
          puts "Dropped #{table}"
        end
      rescue
        $stderr.puts "A problem occurred while dropping tables."
      end
    end
  end
end