Skip to content

Instantly share code, notes, and snippets.

@morriekken

morriekken/rename_column_in_temporal_table.sql

Created June 30, 2020 16:14
Show Gist options
  • Save morriekken/f599d7797e3fe70ac1cf7d09164a181a to your computer and use it in GitHub Desktop.
Save morriekken/f599d7797e3fe70ac1cf7d09164a181a to your computer and use it in GitHub Desktop.
Download ZIP
SQL, Rename column in temporal table
Raw
rename_column_in_temporal_table.sql
ALTER TABLE DatabaseName.SchemaName.TableName SET (SYSTEM_VERSIONING = OFF)
EXEC sp_rename 'DatabaseName.SchemaName.TableName.ColumnName', 'NewColumnName', 'COLUMN';
ALTER TABLE DatabaseName.SchemaName.TableName SET (SYSTEM_VERSIONING = ON (HISTORY_TABLE = SchemaName.HistoryTableName))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment