IF EXISTS (SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'[table1]') AND OBJECTPROPERTY(ID, 'IsTable') = 1) PRINT 'Exist' ELSE PRINT 'Not Exist'