Reserved Words
The Connect data service reserves some words for use internally by the Connect server, xSQL, and xCL. These words have special meaning to Connect. While possible, Xactly recommends developers avoid using them to name domain objects, tables, and columns.
Usage Example
For example, “email” is a reserved word. Connect will throw an error if you try to create a table with a column called email:
create table delta.reserved_word_example (email string(256));
To avoid the error, use surrounding double quotes around the reserved word.
create table delta.reserved_word_example ("email" string(256));
Subsequent SELECT and other SQL statements would also require surrounding double quotes to reference the column.
insert into delta.reserved_word_example ("email") values ('animal@muppets.com');
select "email" from delta.reserved_word_example;
A reserved word may be used as part of an object name without issue (“email_address” instead of the reserved word, “email”).
List of Reserved Words
Note: Words used for xSQL function names and xCL commands and Connect data types are also reserved words, but are not listed here.
- ALL
- ALTER
- AND
- ANTI
- ANY
- AS
- ASC
- BETWEEN
- BY
- CALL
- CASE
- CONTAINS
- CREATE
- DEFINED
- DELETE
- DESC
- DIFFERENCE
- DISTINCT
- DROP
- ELSE
- END
- EXCEPT
- FROM
- FULL
- GROUP
- HAVING
- IF
- IN
- INDEX
- INNER
- INSERT
- INTERSECT
- INTO
- IS
- ITERATOR
- JOIN
- LEFT
- LIKE
- LIMIT
- LIST
- MATCHES
- NATURAL
- NOT
- NULL
- ON
- OR
- ORDER
- OUTER
- PIPELINE
- RIGHT
- SCHEDULE
- SELECT
- SEMI
- SET
- SHOW
- SOME
- STEP
- TABLE
- THEN
- TRUNCATE
- UNION
- UPDATE
- USING
- VALUES
- VARIABLE
- WHEN
- WHERE
- FALSE
- TRUE