Microsoft Dot Net Master
Microsoft Dot Net Master
Wednesday, December 25, 2013
How to delete/drop all the tables from SQL Server
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
this is a hidden SP in sql server, this will be executed for each table in the database you connected
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment