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
ALTER TABLE dbo.MyTable SET (SYSTEM_VERSIONING = OFF);
** Do what ever you want to **
ALTER TABLE dbo.MyTable SET (SYSTEM_VERSIONING = ON);
See this Microsoft article for more info
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With