Options

SQL Table Modification Changeset

pramodcrowepramodcrowe Posts: 3 New member
in SQL Source Control
Can we track Table modification changeset?

If I am adding or removing columns from the tables it always giving the create table command rather than alter.

In case if we have production data it will fail.


Tagged:
· Share on Twitter

Answers

  • Options
    Dan_JDan_J Posts: 450 Silver 2

    Thanks for reaching out to us regarding this.

    Within SQL Source Control there is a an option to see the history of changes, you can see this by right clicking on your database or table within SSMS and selecting 'View History'.

    Regarding your comment around create and alter commands; SQL Source Control uses a 'state based method' (rather than a migration based one), and so it does not 'modify' tables. For example, if you delete a column and replace that column with a new one it will recreate the table so that the latest version of the table can then be committed to your source control solution. It essentially doesn't 'ALTER' tables as such.

    Does this help to answer your query?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.