IF NOT EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1 ) begin SELECT '不存在' END ELSE BEGIN SELECT '存在' end
IF NOT EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1 ) begin SELECT '不存在' END ELSE BEGIN SELECT '存在' end
转载于:https://www.cnblogs.com/dzw159/p/9803400.html