Skip to content

Instantly share code, notes, and snippets.

CREATE TABLE [ExampleTable]
(
[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY
, [SysStartTime] [datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL
, [SysEndTime] [datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL
, [InsertTime] [datetime2](7) NOT NULL
, [TransactionType] [varchar](20) NOT NULL
, PERIOD FOR SYSTEM_TIME ([SysStartTime], [SysEndTime])
)
WITH ( SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[ExampleTableHistory] , DATA_CONSISTENCY_CHECK = ON ));