SQL Server System Versioned Table Scripts
Hello, Here's some of my compiled T-SQL scripts to convert ordinary tables to System Versioned and data manipulation scripts. See below the scripts using ficticious tables and columns. How To Convert An Ordinary Table To A System Versioned Table Use TEST_DB GO ALTER TABLE dbo.tblFileFolders ADD StartTime DATETIME2 GENERATED ALWAYS AS ROW START CONSTRAINT DF_tblFileFolders_StartTime DEFAULT SYSUTCDATETIME(), EndTime DATETIME2 GENERATED ALWAYS AS ROW END CONSTRAINT DF_tblFileFolders_EndTime DEFAULT CONVERT (DATETIME2, '9999-12-31 23:59:59.9999999' ), PERIOD FOR SYSTEM_TIME (StartTime, EndTime); ALTER TABLE dbo.tblFileFolders SET ( SYSTEM_VERSIONING = ON ( HISTORY_TABLE = dbo.tblFileFoldersHistory ) ); How To A Drop System Versioned Table Use TEST_DB GO -- 1. Disable system versioning ALTER TABLE [dbo].[tblFileFolders] SET (SYSTEM_VERSIONING = OFF ); GO -- 2. Dr...