-- Setup
IF OBJECTPROPERTYEX(OBJECT_ID(N'dbo.Thing', 'U'), 'TableTemporalType') = 2
BEGIN
ALTER TABLE dbo.Thing SET (SYSTEM_VERSIONING = OFF);
END;
DROP TABLE IF EXISTS
dbo.Thing,
dbo.ThingHistory;
CREATE TABLE dbo.Thing
(
ThingID integer NOT NULL PRIMARY KEY,
ThingData integer NOT NULL,
ValidFrom datetime2(7) GENERATED ALWAYS AS ROW START NOT NULL,
ValidTo datetime2(7) GENERATED ALWAYS AS ROW END NOT NULL,
PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo),
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.ThingHistory));