日韩欧美国产精品免费一二-日韩欧美国产精品亚洲二区-日韩欧美国产精品专区-日韩欧美国产另-日韩欧美国产免费看-日韩欧美国产免费看清风阁

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 '

方法二 通過查詢系統表

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 '

方法一更安全,