请高手指 - 调试易

请高手指

if object_id('persons..d') is null
print '没有'
else
print '有'

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

1.
use persons
select count(*) from sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
2.
use persons
if exists (select * from sysobjects where id = object_id(N'[dbo].[d]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  print '有'
else
  print '没有'
1、use person
goselect count(*) from sysobjects where type='u'
2、if exists (select 1 from sysobjects where type='u' and name='d')
    print '存在 “D”表'
   else
    print '不存在 “D”表'