Sql Server判断表是否存在

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'不存在'