Posts in "SQL"

Drop/Delete All Tables in a SQL Server Database

When working with complex schemas, there are plenty of situations when you would want to drop/delete all the tables in a SQL Server database. This is pretty easy to do with the sp_msforeachtable stored procedure.  Before executing the scripts bellow, please make sure you are working on the correct database and that your user has… Continue reading