SELECT ISNULL(OBJECTPROPERTY(OBJECT_ID('TableName'), 'IsUserTable'), 0)
存储过程中可以这样判断:
IF OBJECT_ID ('TableName', 'U') IS NOT NULL
存储过程中可以这样判断:
IF OBJECT_ID ('TableName', 'U') IS NOT NULL