请教SQL SERVER中DROP TABLE语句后面为Select查询结果时的写法

IF EXISTS (Select Name from sys.objects WHERe object_id=1995154153)
DROp TABLE 后面怎么写？我希望用一行语句删除查询出来的这张表（但使用下面的语句出错）：

DROP TABLE (Select Name from sys.objects WHERe object_id=1995154153)

--在线等，希望高手显身

select identity(int,0,1) id, name into #t from sys.objects WHERe object_id='1995154153'
declare @s int,@id int,@name varchar(10)
set @s=1
select @id =sum(id) from #t
while @S<@id
begin
select @name=name from #t where id=@s;
print @name
exec('drop table '+@name)
set @s=@s+1
end

额