use DBName
declare @name varchar(32)
while(exists(select * from sysobjects where xtype='u' and name like 'AA_%'))
begin
select @name=name from sysobjects where xtype='u' and name like 'AA_%'
exec ('drop table '+@name)
end
use DBName
declare @name varchar(32)
while(exists(select * from sysobjects where xtype='u' and name like 'AA_%'))
begin
select @name=name from sysobjects where xtype='u' and name like 'AA_%'
exec ('drop table '+@name)
end
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
