How To Drop All Tables In An SQL Server Database
Read Time:15 Sec
I’ve been doing a lot of work with SQL Server lately and have found the following SQL that can be used to drop (delete) all tables in an SQL Server database:
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Do you have any really handy SQLs? Post them in the comments.
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating