SQL Display of Matching Begin-End Tokens

The SQL development tools support the display of matching brackets and matching begin-end blocks. You can make SQL statements more readable by using this feature.

Select a token, then use the shortcut key, Ctrl+Shift+P, to move to the matching pair token. You can modify the shortcut key preference settings by using Window > Preferences > General > Keys .

Use this feature in any of the following:

SQL Scrapbook
Source page for triggers, Adaptive Server Enterprise INSTEAD OF triggers, stored procedures, user-defined functions, and SQL Anywhere or Sybase IQ events.
Debug page for stored procedures, user-defined functions, and SQL Anywhere or Sybase IQ events.

The following table identifies supported tokens by database server:

SQL for database server	Supported matching tokens
General SQL (non-Sybase)	“(”, “)” , “[”, “]”, “begin”, “end”, “BEGIN”, “END”
Adaptive Server Enterprise, versions 12.5.2 to 15.0.x	“(”, “)” , “[”, “]”, “begin”, “end”, “BEGIN”, “END”, “case”, “CASE”, “end case”, “END CASE”, “if”, “IF” , “end if”, “END IF”
SQL Anywhere, 9.x or later	“(”, “)” , “[”, “]”, “begin”, “end”, “BEGIN”, “END”, “case”, “CASE”, “end case”, “END CASE”, “if”, “IF” , “end if”, “END IF”, “endif”, “ENDIF”, “loop”, “LOOP”, “end loop”, “END LOOP”, “for”, “FOR”, “end for”, “END FOR”
Sybase IQ, 12.x or later	“(”, “)” , “[”, “]”, “begin”, “end”, “BEGIN”, “END”, “case”, “CASE”, “end case”, “END CASE”, “if”, “IF” , “end if”, “END IF”, “endif”, “ENDIF”, “loop”, “LOOP”, “end loop”, “END LOOP”, “for”, “FOR”, “end for”, “END FOR”