可重复升级SQL语句

--字段的可重复升级
IF NOT EXISTS(SELECT c.Name  
                      from sysobjects s  
                     inner join syscolumns c on s.id = c.id  where object_name(s.ID)='HM_EM_WorkInfo' and c.Name = 'InJobDate')
BEGIN  
     ALTER TABLE HM_EM_WorkInfo ADD [InJobDate] [Datetime] null
END
GO
--表的可重复升级


IF NOT EXISTS (SELECT 1 FROM  SYSOBJECTS  WHERE  ID = OBJECT_ID('HR_SMS_OuterLinkman')  and   type = 'U')
BEGIN
create table HR_SMS_OuterLinkman (
   ID                   uniqueidentifier             not null,
   Name                 nvarchar(20)             not null,
   Mobile               nvarchar(20)             not null,
   Email                nvarchar(50)             null,
   Address              nvarchar(100)             null,
   Note                 nvarchar(250)             null,
   UserID               uniqueidentifier             not null,
   constraint PK_HR_SMS_OUTERLINKMAN primary key  (ID)
)
END
GO


--视图的可重复升级
IF EXISTS (SELECT 1 from sysobjects WHERE id = object_id(N'[视图名称 ]') AND OBJECTPROPERTY(id, N'IsView') = 1)
BEGIN
DROP VIEW 视图名称 
END
GO


Create  VIEW 视图名称 
AS


GO


--存储过程的可重复升级


IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE name ='HR_P_Rpt_EmployeeRedploy' and type='p')
begin
     drop PROC 存储过程名
end
GO




create proc 存储过程名
(
参数
)
AS 
BEGIN
END
GO
--外键的可重复升级
if not exists(select * from sysobjects where name='FK_HR_SMS_S_REFERENCE_HR_SMS_S' and xtype = 'F')
BEGIN
alter table HR_SMS_SMSItemOption
   add constraint FK_HR_SMS_S_REFERENCE_HR_SMS_S foreign key (ItemID)
      references HR_SMS_SMSQuenssiareItem (ID)
END
go




--索引的可重复升级
IF NOT EXISTS (SELECT 1 
                    FROM sysindexes 
                       WHERE id = OBJECT_ID('AP_Objective_Activities') 
                            AND name = 'idx_AP_Objective_Activities_ProcInstIDNodeID')
    CREATE INDEX idx_AP_Objective_Activities_ProcInstIDNodeID
              ON AP_Objective_Activities
               (
                     ProcInstID    ASC,
                     NodeID        ASC
               )
GO


--主键的可重复升级
IF NOT EXISTS (SELECT 1  FROM SYSOBJECTS WHERE name ='PK_Wf_WorkItemParticipants') 
ALTER TABLE Wf_WorkItemParticipants ADD CONSTRAINT PK_Wf_WorkItemParticipants PRIMARY KEY 
CLUSTERED 
 (
    WorkItemId,
    ParticipantId
 ) ON [PRIMARY] 
GO
--字段约束的可重复升级
IF NOT EXISTS (SELECT 1  FROM SYSOBJECTS WHERE name ='DF_HR_MothballManpower_IsDefaultSingletonValue')
ALTER TABLE [HR_MothballManpower] ADD CONSTRAINT [DF_HR_MothballManpower_IsDefaultSingletonValue] DEFAULT (0) FOR [IsDefaultSingletonValue]
GO


--触发器的可重复升级
if exists(select 1 from sysobjects where name='触发器物理名称' and type='TR')
Drop TRIGGER  触发器物理名称
GO
Create TRIGGER 触发器物理名称 ON 表的名称
FOR INSERT
AS
BEGIN
END
GO