SQLServer判断表是否存在

select * from? dbo.sysobjects where id =object_id(N'statisticalData')

?

if object_id(N'BMS_Alarm',N'U') is not null
print '存在'
else
print '不存在'

?if not exists ( select * from dbo.sysobjects where id = object_id('AddAlarmItem') and OBJECTPROPERTY(id,N'IsUserTable')=1)
? ? print 1
? ? else
? ? print 0

--判断临时表是否存在 ?if object_id('tempdb..#hs') is not null ? print 1? ?else ? print 2 --判断物理表是否存在 if exists (select * from sysobjects where id=object_id(N'BMS_Alarm') and OBJECTPROPERTY(id,N'IsUserTable')=1) print 1 else? print 2

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!