ALTER index vs DROP when alter is possible

[sebling]

When changing rebuild index options e.g. ALLOW_PAGE_LOCKS is it possible for SQL Compare to generate an ALTER INDEX REBUILD WITH rebuild index options rather than a drop and create?
Would simplify deployments to replicated tables when a DROP and CREATE are not strictly required.
Thanks - your products are my lifeline!

[Brian Donahue]

I have logged a support call for you with reference F0068435. We will be in touch shortly.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[james.billings]

Hi Steve,
I've had a quick look and don't see an option that may help here, and I also don't spot an existing request for it either.

I'm happy to log it in our internal bugtracker but could I ask you to send over a "before" and "after" table definition that triggers the behaviour you're wanting to avoid so the development team are understanding you correctly? You can post that here, or mail it in on your ticket (F0068435 in the subject line).

You may also want to add it to our Uservoice site for SQL Compare so other users can vote-up the change.