--(1) IF EXISTS (Select * From sysobjects where id=object_ID(N'YourTableName') AND Xtype='U') Print 'Exists' Else Print 'Not exists'--(2). IF OBJECT_ID(N'YourDB.dbo.YourTableName') IS NULL Print 'Not exists' Else Print 'Exists'
--(1) IF EXISTS (Select * From sysobjects where id=object_ID(N'YourTableName') AND Xtype='U') Print 'Exists' Else Print 'Not exists'--(2). IF OBJECT_ID(N'YourDB.dbo.YourTableName') IS NULL Print 'Not exists' Else Print 'Exists'
if (object_id('表名') is not null and OBJECTPROPERTY(object_id('表名'),'IsUserTable') = 1) print 'exists' else print 'not exists'
IF EXISTS (Select * From sysobjects where id=object_ID(N'YourTableName') AND Xtype='U')
Print 'Exists'
Else
Print 'Not exists'--(2).
IF OBJECT_ID(N'YourDB.dbo.YourTableName') IS NULL
Print 'Not exists'
Else
Print 'Exists'
IF EXISTS (Select * From sysobjects where id=object_ID(N'YourTableName') AND Xtype='U')
Print 'Exists'
Else
Print 'Not exists'--(2).
IF OBJECT_ID(N'YourDB.dbo.YourTableName') IS NULL
Print 'Not exists'
Else
Print 'Exists'
print 'exists'
else
print 'not exists'