-- 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));