IF NOT EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N‘[表名]‘) AND OBJECTPROPERTY(id, N‘IsUserTable‘) = 1 )beginSELECT ‘不存在‘ENDELSEBEGIN SELECT ‘存在‘end