SQL 判断 临时表是否存在

判断临时表是否存在

Create Table  #tmpKeyWordLink

(

id int

)



  if exists(select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tempKeyWordLink') and type='U')

     drop table #tempKeyWordLink