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:
Original statement (formatting fails)
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 126.96.36.199 .
P.S. Just found out this is the core problem behind another issue described here!
create_index_sample.sql (276 Bytes)