DECLARE @strTableName as nvarchar(40);
DECLARE cur_table CURSOR FOR select NAME from sysobjects where xtype='U'
AND NAME LIKE '%BAK%'
OPEN cur_table;
FETCH NEXT FROM cur_table INTO @strTableName
WHILE @@FETCH_STATUS=0
BEGIN
Exec('DROP TABLE dbo.'+@strTableName)
FETCH NEXT FROM cur_table INTO @strTableName
END
CLOSE cur_table --关闭游标
DEALLOCATE cur_table; --释放游标
