The Syntax category is located in the category, and contains the following items that define the DBMS-specific syntax:
|
Item |
Description |
|---|---|
|
BlockComment |
Specifies the character used to enclose a multi-line commentary. Example: /* */ |
|
BlockTerminator |
Specifies the end of block character, which is used to end expressions for triggers and stored procedures. |
|
Delimiter |
Specifies the field separation character. |
|
IdentifierDelimiter |
Specifies the identifier delimiter character. When the beginning and end delimiters are different, they must be separated by a space character. |
|
LineComment |
Specifies the character used to enclose a single line commentary. Example: %% |
|
Quote |
Specifies the character used to enclose string values. Note that the same quote must be used in the check parameter tab to enclose reserved words used as default. |
|
SqlContinue |
Specifies the continuation character. Some databases require a continuation character when a statement is longer than a single line. For the correct character, refer to your DBMS documentation. This character is attached to each line just prior to the linefeed. |
|
Terminator |
Specifies the end of statement character, which is used to terminate create table, view, index, or the open/close database, and other statements. If empty, BlockTerminator is used instead. |
|
UseBlockTerm |
Specifies the use of BlockTerminator. The following settings are available: |