Generally, only the question mark
? is treated as a parameter in SQL statements. On this page, you can specify which other characters and their sequences should be treated as parameters, and in which places.
The patterns for SQL parameters are specified by means of regular expressions.
Enable in console and SQL files
If the checkbox is selected, the parameter patterns are applied to SQL (in SQL files and database consoles). The usage scope, if necessary, may be limited at the level of individual patterns.
If this checkbox is cleared, the patterns are not used in SOL files and consoles irrespective of which usage scope is specified for individual patterns.
Enable in string literals with SQL injection
If this checkbox is cleared, the patterns are not used in string literals irrespective of which usage scope is specified for individual patterns.
The table shows the parameter patterns and their usage scopes.
The patterns are specified using regular expressions. Values in parentheses are treated as parameter names. The patterns available initially have the following meanings:
Use Ctrl+N, Ctrl+R, D, Alt+Up and Alt+Down to add, delete and reorder the patterns.
To edit a pattern or its usage scope, click the pattern and use the following controls: