declare @tname varchar(20) while(exists(select * from sysobjects where name like 'a%')) begin select @tname=name from sysobjects where name like 'a%' exec ('drop table '+@tname) end