CODEWITHSUNDEEP
.netsql-servervisual-studio-2010sql-server-data-tools
Andie
Andie

Reputation: 21

Avoid table rebuild when adding or removing a column?

Adding or removing a column using SQLPAckage (SSDT) causes the table to be rebuilt. Is there a workaround for this?

Upvotes: 2

Views: 1745

Answers (1)

Peter Schott
Peter Schott

Reputation: 4681

If you're adding a column anywhere but the end of the table, that will definitely trigger a table rebuild. You shouldn't see you table rebuilding otherwise. You may want to try a Schema Compare to see what SSDT thinks is going to change. That would show you the differences it sees and could give you more insight into why your table is being rebuilt.

This is not normally the case. It could be triggered by a change in collation, but should otherwise just use an ALTER TABLE command.

Upvotes: 2

Related Questions