Do not recreate tables when changing a computed columns
It is very annoying that Source Control always recreates a table, just because I change a computed column instead to drop / recreate only the column (the FORCE-COLUMN-ORDER option is set to false so this could not be the reason).
Particulary if it is on one of your big tables with lots of indexes, FKs ...
I know there may be reasons to recreate a table if you add / drop / alter columns (because of possible page splits) but I want to decide it by myself (e.g. by adding a migration script for this rare cases)
10
votes
Thomas Franz
shared this idea