Toad World® Forums

BUG: The T-SQL formatter doesn't work when statement contains "ONLINE" clause!



I’ve noticed that the built-in formatter doesn’t work on my “CREATE INDEX…” code (see the attached SQL). Quick investigation has shown the “ONLINE = OFF,” clause prevents proper formatting of the code. Here are two screenshots of the editor with and w/o this clause:

  1. Original statement (formatting fails)

  2. The “ONLINE = OFF,” clause is commented out and T-SQL is formatted properly.

The problem seems to affect Toad for SQL Server 6.6, as well as the latest beta .

P.S. Just found out this is the core problem behind another issue described here!
create_index_sample.sql (276 Bytes)


I’ve logged this, will fix asap. (QP-1182)

Thanks for reporting.