Project

General

Profile

Экстендер MdbHistoryBrowser » PH_HISTORY_DROP.sql

Sergey Kolyshkin, 26/01/2023 18:19

 
--USE [pioner]

GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[components]') AND type in (N'U'))
BEGIN
DELETE FROM dbo.components WHERE name='mdb.ph_history'
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_UserName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_UserName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_HostName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_HostName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_ModifyDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_ModifyDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_OP_Code]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_OP_Code]
END

GO

/****** Object: Table [dbo].[PH_HISTORY] Script Date: 09/28/2012 15:06:28 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PH_HISTORY]') AND type in (N'U'))
DROP TABLE [dbo].[PH_HISTORY]
GO

/****** Object: Trigger [History_Updated] Script Date: 09/28/2012 14:36:46 ******/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Updated]'))
DROP TRIGGER [dbo].[History_Updated]
GO

/****** Object: Trigger [History_Deleted] Script Date: 09/28/2012 14:38:48 ******/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Deleted]'))
DROP TRIGGER [dbo].[History_Deleted]
GO

/****** Object: Trigger [History_Inserted] Script Date: 09/28/2012 14:39:02 ******/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Inserted]'))
DROP TRIGGER [dbo].[History_Inserted]
GO

/****** Object: Trigger [History_Attr_Deleted] Script Date: 09/28/2012 14:39:02 ******/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Attr_Deleted]'))
DROP TRIGGER [dbo].History_Attr_Deleted
GO

/****** Object: Trigger [History_Attr_Inserted] Script Date: 09/28/2012 14:39:02 ******/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Attr_Inserted]'))
DROP TRIGGER [dbo].History_Attr_Inserted
GO
(7-7/7)
Add picture from clipboard (Maximum size: 742 MB)