Contents tagged with delete everything from db

  • Delete all tables from db in ms sql

    For purpose of deleting all tables in MS SQL fitting is:

    EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

    This is a hidden stored procedure in sql server that will be executed for each table in the database you chosen.

    Also here described how to imitate drop in db  more