A simple cursor deletes the SQL Server table

Use DatabaseName
Declare @tblname char (100)
Declare @sql char (5000)
Declare table_cursor cursor for select name from sysobjects where name like ' tb_card[_]% ' and name<> ' Tb_card_regi St ' and Name<> ' Tb_card_item ' and name<> ' tb_card_discrule ' and name<> ' Tb_card_packagesetdetail ' and Name<> ' Tb_card_packagedetail ' and name<> ' Tb_card_exchangeitem '
and name<> ' Tb_card_package '
Open Table_cursor

FETCH NEXT from Table_cursor to @tblname
While @ @FETCH_STATUS = 0
BEGIN
Set @sql = ' Delete from ' + @tblname
EXEC (@sql)
print ' delete ' + @tblname + ' successful '
FETCH NEXT from Table_cursor to @tblname
END
Close Table_cursor
Deallocate table_cursor

A simple cursor deletes the SQL Server table