How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?

发布时间 2023-06-16 15:31:49作者: ChuckLu

How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?

回答1

My problem was solved when i using following query:

-- SET SYSTEM_VERSIONING TO OFF
ALTER TABLE [dbo].[MyTable]
SET (SYSTEM_VERSIONING = OFF)
GO

** Do what ever you want to **

-- SET SYSTEM_VERSIONING TO ON
ALTER TABLE [dbo].[MyTable]
SET 
    (SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[MyTable_Archive] , DATA_CONSISTENCY_CHECK = ON ))
GO