Removing all User Defined Tables at one shot using sp_MSforeachtable Stored Procedure.

Posted by vishalneeraj-24503 under Sql Server category on 12/30/2014 | Points: 40 | Views : 943

Below query will delete or remove all User Defined Table from Database.

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

Bookmark It

Latest Code Snipptes