Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?

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