SQL Table Modification Changeset

pramodcrowe

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.

Dan_J

Hi @pramodcrowe

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?