如何在 SQL Server 2016 中的系统版本化临时表上停止系统版本控制? [英] How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?

问题描述

我有一个具有系统版本控制的表(时态表)，但我无法直观地看到设计环境.我这样做是因为我可以看到使用了 SYSTEM_VERSIONING 子句.我想暂时停止然后启用它.谁能给我建议?

I have a table that has system versioning (temporal table), but I can not see a design environment visually. I do it because I can see the SYSTEM_VERSIONING clause has been used. I would like to have temporarily Stop and then enable it. Who can advise me?

推荐答案

当我使用以下查询时，我的问题得到解决:

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

这篇关于如何在 SQL Server 2016 中的系统版本化临时表上停止系统版本控制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！