SQL Server 如果表存在执行删除

SQL Server 如果表存在执行删除

use Budget  --使用Budget数据库go IF EXISTS(Select 1 From Sysobjects Where Name='costSeparateConfig')  --查询表名costSeparateConfig是否存在DROP table costSeparateConfig     --存在则删除GOgo--创建新表CREATE  TABLE  costSeparateConfig(      ID int IDENTITY(1,1) NOT NULL, COMPANY_ID varchar(50) NOT NULL,IS_SEP varchar(50) NULL,CREATE_BY numeric(18, 0) NULL,CREATE_DATE datetime NULL,LAST_UPDATE_BY numeric(18, 0) NULL,LAST_UPDATE_DATE datetime NULL)ON [PRIMARY]GOSET ANSI_PADDING OFFGO

SQL Server 如果视图存在执行删除

IF EXISTS(Select Name From Sysobjects Where Name='P_ExistsDropView' And Xtype='P')DROP PROC P_ExistsDropViewGOCreate Proc P_ExistsDropView(@DelView Varchar(200))AsDeclare @SQLText Varchar(1000)If Exists(Select Top 1 Name From Sysobjects Where Name=@DelView And XType='V') Begin  Set @SQLText='Drop View ' + @DelView  Exec(@SQLText)End