SQLServer uses the t-SQL command to delete specified tables in the database in batches (Delete tables cyclically with a cursor)

When we need to delete tables in the database in batches, do we get bored and get tired of deleting a single table? We can simply use a script.

This script uses cursors to delete objects cyclically. for a small number of objects, using a cursor will not cause any adverse impact.

Copy codeThe Code is as follows:
DECLARE @ tablename VARCHAR (30 ),
@ SQL VARCHAR (500)
DECLARE cur_delete_table CURSOR READ_ONLY FORWARD_ONLY
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