Remove all Tables
Go
-- drop all user defined tables
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Monday, 6 April 2015
SQL SERVER - How to delete all tables in database
Remove all Tables
Go
-- drop all user defined tables
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
0 comments:
Post a Comment
Get Benifits