Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/turn_on_temporal.sql

Created October 10, 2017 17:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tdmitch/ae7df377db823d9f741b8208e73f1e0b to your computer and use it in GitHub Desktop.
Save tdmitch/ae7df377db823d9f741b8208e73f1e0b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
turn_on_temporal.sql
/* Turn on system versioning */
ALTER TABLE dbo.Customers
SET (SYSTEM_VERSIONING = ON
(
HISTORY_TABLE = [dbo].[CustomersHistory]
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment