sql server 判断数据库表是否存在

1:判断正常表 select count(*) from SysObjects where XType='U' and name ='table'
2:判断临时表 if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#temp1')) 
posted @ 2011-07-06 16:58  txsun  阅读(431)  评论(0编辑  收藏  举报