SQL Server uses the T-SQL command to bulk delete a specified table in a database (cursor looping delete) _mssql

When we need to bulk delete the tables in the database, whether a single delete some of the table is annoying, tired, simply write a script to use.

This script uses cursor looping to delete, and for a smaller number, cursors are not adversely affected.

Copy Code code as follows:

DECLARE @tablename VARCHAR (30),
@sql VARCHAR (500)
DECLARE cur_delete_table CURSOR read_only forward_only for
SELECT name from sysobjects WHERE name like ' pub% ' and type= ' U '
OPEN cur_delete_table
FETCH NEXT from cur_delete_table into @tablename
While @ @FETCH_STATUS = 0
BEGIN
SELECT @sql = ' drop table ' + @tablename
EXEC (@sql)
FETCH NEXT from cur_delete_table into @tablename
End
Close Cur_delete_table
Deallocate cur_delete_table