how to delete tables in sql?

Learn How to Delete or Remove Database Table using SQL

If you want to use only one SQL query to delete all tables you can use this: EXEC sp_MSforeachtable @command1 = “DROP TABLE ?” This is a hidden Stored Procedure in sql server, and will be executed for each table in the database you’re connected.

The SQL DELETE Statement

Leave a Comment

Share via
Copy link
Powered by Social Snap