Alter only indexes

code

Hi,

Please forgive me if this has been asked before but I'd like to update only indexes and make no changes to table definitions i.e columns etc.

I know this could have implications if indexes are being created on columns that do not exist but I will be making sure this does not happen.

I couldn't see any options to only include constraints and indexes in the final SQL script that is generated.

Many thanks if anyone can help.

code

Hi,

Is there any chance I would be able to do something like this with SQL Compare?

Many thanks

Eddie D

Hi

Thank you for your post into the forum.

This option does not exist in SQL Compare.

You cannot compare just Indexes or constraints as objects on their own in the manner you are seeking using SQL Compare.

To compare and view the differences in your Indexes or Constraints, you must compare the tables and views that use the Index or constraint.

Many Thanks

Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: support@red-gate.com