Alter only indexes

codecode Posts: 11
edited April 25, 2007 8:48AM in SQL Compare Previous Versions

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.


  • Hi,

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

    Many thanks
  • Eddie DEddie D Posts: 1,674 Rose Gold 5

    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: [email protected]
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.