if object_id(N'QueryRecord',N'U') is not null
print N'存在'
else
print N'不存在'
IF EXISTS (SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'QueryRecord') AND OBJECTPROPERTY(ID, 'IsTable') = 1)
PRINT N'存在'
ELSE
PRINT N'不存在'
if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TEMP_TBL') and type='U')
PRINT N'存在'
ELSE
PRINT N'不存在'
if exists (select * from CCGS_PuDao_FC.dbo.sysobjects where id = object_id(N'CCGS_PuDao_FC..QueryRecord') and type='U')
PRINT N'存在'
ELSE
PRINT N'不存在'
Sql Server判断表是否存在
最新推荐文章于 2024-04-26 09:11:45 发布