In a previous job where I used Microsoft's SSDT for version control and schema compare, I could modify a table definition to add an index. In the process, I could format it however I preferred and add comments for each column in the index indicating what stored procedures it was intended to benefit. When it compared the file on disk (repository) to the database, it would consider the two to be identical even though the version in the database was formatted differently and had no comments.
With Toad, if I modify the script in the repository with a formatted CREATE INDEX statement and check it in and also run it in the database, the table is categorized as "Merge" in the Perspective tab and the "Show changes" view seem to be doing a character by character comparison rather than a logical one.
Is there any way to achieve my goal using Toad? Keep in mind that I may want to have a different comment on each column in the index. (Sadly, SQL Server doesn't support extended properties on columns in an index, just the one unformatted text item for the entire index. Otherwise that might have been an acceptable workaround.)