--临时表的判断 if object_id('tempdb..#tempQuFen') is not null drop table [dbo].[#tempQuFen] --物理表的判断 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Temp_FenDuan_TongJi_All]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Temp_FenDuan_TongJi_All]