Keywords Category (DBMS)

CharFunc

Specifies a list of SQL functions to use with characters and strings.

Example:

char()
charindex()
char_length() etc

Commit

Specifies a statement for validating the transaction by live connection.

ConvertFunc

Specifies a list of SQL functions to use when converting values between hex and integer and handling strings.

Example:

convert()
hextoint()
inttohex() etc

DateFunc

Specifies a list of SQL functions to use with dates.

Example:

dateadd()
datediff()
datename() etc

GroupFunc

Specifies a list of SQL functions to use with group keywords.

Example:

avg()
count()
max() etc

ListOperators

Specifies a list of SQL operators to use when comparing values, boolean, and various semantic operators.

Example:

=
!=
not like etc

NumberFunc

Specifies a list of SQL functions to use with numbers.

Example:

abs()
acos()
asin() etc

OtherFunc

Specifies a list of SQL functions to use when estimating, concatenating and SQL checks.

Example:

db_id()
db_name()
host_id() etc

Reserved Default

Specifies a list of keywords that may be used as default values. If a reserved word is used as a default value, it will not be enquoted.

Example (SAP® Sybase® SQL Anywhere® 10) - USER is a reserved default value:

Create table CUSTOMER (
Username varchar(30) default USER
)

When you run this script, CURRENT DATE is recognized as a reserved default value.

ReservedWord

Specifies a list of reserved keywords. If a reserved word is used as an object code, it is enquoted during generation (using quotes only in DBMS > Script > SQL > Syntax > Quote).