sql server 判断某存储过程,某表,某表栏位是否存在 避免脚本重复

存储过程

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[USP_*****]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[USP_*****]
GO

 

表

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table**]') AND type in (N'U'))
DROP TABLE [dbo].[table**]
GO

 

表栏位

IF  EXISTS (select * from syscolumns where id=(select id from sysobjects where name='table**']) and name='Remark')
alter  TABLE table**  DROP COLUMN  Remark
alter  table table** add Remark nvarchar(2000) NULL
UPDATE  table**  SET Remark = '' WHERE Remark IS NULL