SQL学习之查询技巧 查询表是否存在的两种方法
方法一 判断系统对象是否存在
DECLARE
@DbTableFileName VARCHAR ( 100 )
SET @DbTableFileName = ' tx '
IF objectproperty ( object_id ( @DbTableFileName ), ' IsUserTable ' ) IS NOT NULL
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
IF object_id ( @DbTableFileName ) IS NOT NULL
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
IF EXISTS ( SELECT Object_id ( @DbTableFileName ))
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
@DbTableFileName VARCHAR ( 100 )
SET @DbTableFileName = ' tx '
IF objectproperty ( object_id ( @DbTableFileName ), ' IsUserTable ' ) IS NOT NULL
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
IF object_id ( @DbTableFileName ) IS NOT NULL
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
IF EXISTS ( SELECT Object_id ( @DbTableFileName ))
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
方法二 通过查询系统表
DECLARE
@DbTableFileName VARCHAR ( 100 )
SET @DbTableFileName = ' tx '
IF EXISTS ( SELECT 1
FROM sysobjects
WHERE name = @DbTableFileName
AND TYPE = ' u ' )
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
@DbTableFileName VARCHAR ( 100 )
SET @DbTableFileName = ' tx '
IF EXISTS ( SELECT 1
FROM sysobjects
WHERE name = @DbTableFileName
AND TYPE = ' u ' )
PRINT ' EXISTS '
ELSE
PRINT ' NOT EXISTS '
整理自http://community.csdn.net/Expert/topic/5283/5283952.xml?temp=.733227
谢谢loomman (一剑) xiequanqin(新的一天,新的起点!) marco08(天道酬勤) bugchen888(臭虫) caixia615(*^_^*)‵My ɡīr!.ˊ想念妳ˋ 。(*^_^*)