Skip to content

Instantly share code, notes, and snippets.

@mwwhited

mwwhited/RevertSqlSystemVersioned.md

Created December 23, 2020 19:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mwwhited/554cecd0036de1248314f9930bade777 to your computer and use it in GitHub Desktop.
Save mwwhited/554cecd0036de1248314f9930bade777 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RevertSqlSystemVersioned.md

Revert System Versioned tables

ALTER TABLE dbo.your_table
	DROP CONSTRAINT DF_SysStart , DF_SysEnd 
ALTER TABLE dbo.your_table
	DROP PERIOD FOR SYSTEM_TIME
ALTER TABLE dbo.your_table
	DROP COLUMN [SysStartTime], [SysEndTime]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment