Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/createschema.sql

Created June 1, 2018 01:06
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/aa8b499d546a47d66f82125379b7cd2b to your computer and use it in GitHub Desktop.
Save tdmitch/aa8b499d546a47d66f82125379b7cd2b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
createschema.sql
CREATE SCHEMA [etl]
/*
User-defined table to store the most recent change tracking version ID
processed via ETL.
*/
CREATE TABLE [etl].[Change_Tracking_Version]
(
[Table_Name] VARCHAR(100) NOT NULL PRIMARY KEY
, [Change_Tracking_Version] [BIGINT] NULL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment