1. declare @sql nvarchar(4000) select @sql=isnull(@sql,'')+'drop table '+name+'; ' from sys.objects where type='U' and name like '%ABC%' exec(@sql)2. declare @sql nvarchar(4000) select @sql=isnull(@sql,'')+'drop table '+name+'; ' from sys.objects where type='U' and name like 'ABC%' exec(@sql)
declare @sql nvarchar(4000)
select @sql=isnull(@sql,'')+'drop table '+name+'; ' from sys.objects where type='U' and name like '%ABC%'
exec(@sql)2.
declare @sql nvarchar(4000)
select @sql=isnull(@sql,'')+'drop table '+name+'; ' from sys.objects where type='U' and name like 'ABC%'
exec(@sql)
2.我想删除数据表名前面为'ABC'前缀的的数据表第一个删除就把第二个要删除的都一起删除了呀。