if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_RptFile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[T_RptFile] GO
is object_id('[dbo].[T_RptFile]','U') is not null drop table [dbo].[T_RptFile] go--or is object_id('[dbo].[T_RptFile]','U') >0 drop table [dbo].[T_RptFile] go这样写简单点
if object_id('[dbo].[T_RptFile]','U') is not null drop table [dbo].[T_RptFile] go--or if object_id('[dbo].[T_RptFile]','U') >0 drop table [dbo].[T_RptFile] go一楼手误,修正一下
drop table [dbo].[T_RptFile]
go--or is object_id('[dbo].[T_RptFile]','U') >0
drop table [dbo].[T_RptFile]
go这样写简单点
drop table [dbo].[T_RptFile]
go--or if object_id('[dbo].[T_RptFile]','U') >0
drop table [dbo].[T_RptFile]
go一楼手误,修正一下
如果T_RptFile存在而且是用户表,非系统表,就删除掉T_RptFile。