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

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 238
Below query will delete or remove all User Defined Table from Database.

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?" 

Comments or Responses

Login to post response