Posts Tagged ‘delete’

How to delete/drop all the tables from SQL Server

If we want to delete or drop all the tables from SQL Server Database. 1) This is a hidden Stored procedure in sql server, this will be executed for each table in the database you connected. This cant be roll back. EXEC sp_MSforeachtable @command_delete = “DROP TABLE ?” 2)If u want to delete it from […]

Powered by k2schools