使用游标删除固定开头的表

SET NOCOUNT ON ;
declare @sql varchar(4000) ,@i int
set @i = 1 ;
declare c cursor for
--select ' select top 0 * into '+ quotename ( 'tmp_dataltl_'+ name ) + ' from ' + quotename( name ) +'; ' from sysobjects where xtype = 'u' and name not like 'tmp_dataltl%'
select ' drop table ' + quotename( name ) +' ; ' from sysobjects where name like 'tmp_data_%'
open c ;
fetch c into @sql
while @@fetch_status = 0
begin
--print @i
--print @sql
exec ( @sql )
set @i = @i + 1
fetch c into @sql
end
close c ;
deallocate c;