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 .
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.0 or 10.0 | “(”, “)” , “[”, “]”, “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.0 | “(”, “)” , “[”, “]”, “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” |
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.