【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:LocalDataCache1.dbo.Customers.undo.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
/****
璀﹀憡
涓轰簡闃叉浠讳綍娼滃湪鐨勬暟鎹涪澶遍棶棰橈紝鎮ㄥ簲璇ュ湪杩愯鑴氭湰涔嬪墠
瀵瑰叾杩涜璇︾粏妫鏌ャ?
姝?SQL 鑴氭湰鏄敱鈥滈厤缃暟鎹悓姝モ濆璇濇
鐢熸垚鐨勩傛鑴氭湰琛ュ厖浜嗗彲鐢ㄤ簬鍒涘缓璺熻釜鏇存敼鎵闇鐨?
蹇呰鏁版嵁搴撳璞$殑鑴氭湰銆傛鑴氭湰
鍖呭惈鐢ㄤ簬绉婚櫎姝ょ被鏇存敼鐨勮鍙ャ?
鏈夊叧鏇村淇℃伅锛岃鍙傝甯姪涓殑鈥滃浣? 閰嶇疆鏁版嵁搴撴湇鍔″櫒杩涜鍚屾鈥濄?
****/
IF @@TRANCOUNT > 0
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
BEGIN TRANSACTION;
IF @@TRANCOUNT > 0
ALTER TABLE [dbo].[Customers] DROP CONSTRAINT [DF_Customers_LastEditDate]
GO
IF @@ERROR <> 0
ROLLBACK TRANSACTION;
IF @@TRANCOUNT > 0
ALTER TABLE [dbo].[Customers] DROP COLUMN [LastEditDate]
GO
IF @@ERROR <> 0
ROLLBACK TRANSACTION;
IF @@TRANCOUNT > 0
ALTER TABLE [dbo].[Customers] DROP CONSTRAINT [DF_Customers_CreationDate]
GO
IF @@ERROR <> 0
ROLLBACK TRANSACTION;
IF @@TRANCOUNT > 0
ALTER TABLE [dbo].[Customers] DROP COLUMN [CreationDate]
GO
IF @@ERROR <> 0
ROLLBACK TRANSACTION;
IF @@TRANCOUNT > 0
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Customers_Tombstone]') and TYPE = N'U')
DROP TABLE [dbo].[Customers_Tombstone];
IF @@TRANCOUNT > 0
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Customers_DeletionTrigger]') AND type = 'TR')
DROP TRIGGER [dbo].[Customers_DeletionTrigger]
GO
IF @@TRANCOUNT > 0
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Customers_UpdateTrigger]') AND type = 'TR')
DROP TRIGGER [dbo].[Customers_UpdateTrigger]
GO
IF @@TRANCOUNT > 0
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Customers_InsertTrigger]') AND type = 'TR')
DROP TRIGGER [dbo].[Customers_InsertTrigger]
GO
COMMIT TRANSACTION;