There are a number of keywords belonging to the SAND CDBMS SQL grammar. It is recommended that these keywords not be used as names for the following database objects: columns, domains, schemas, tables, user authorizations, and views. Doing so will result in errors whenever the object name is interpreted as an SQL keyword.
Also, avoid using data type names for columns when working with SAND Analytic Explorer or any front-end tool: LONG VARCHAR, BIT, TINYINT, BIGINT.
Keywords:
A - B - C - D - E - F- G - H - I - J - K - L - M - N - O - P - Q - R- S - T - U - V - W - Y
ABS | ABSVAL | ACOS | ADD | AFTER | AGE | ALL | ALTER | AND | ANY | AS | ASC | ASCII | ASIN | ASYMMETRIC | ATAN | ATOMIC | AUTHORIZATION | AVG
BACKWARD | BEFORE | BEGIN | BETWEEN | BINARY_UPCASE | BLOB | BOOLEAN | BOTH | BOTTOM | BY
CALL | CASCADE | CASE | CEIL | CEILING | CGRXDB | CHANGE | CHAR | CHARACTER | CHECK | CHECKPOINT | CHR | CLOSE | COALESCE | COLLATE | COLUMN | COLUMN_NAME | COMMAND_FUNCTION | COMMAND_FUNCTION_CODE | COMMIT | COMMITTED | COMPACT | CONCAT | CONDITION | CONDITION_NUMBER | CONNECT | CONNECTION | CONSTRAINT | CONSTRAINTS | CONSTRAINT_NAME | CONSTRAINT_SCHEMA | CONTINUE | COPY | COS | COUNT | CREATE | CREATETAB | CURRENT | CURRENT_USER | CURSOR | CURSOR_NAME
DATABASE | DATE | DAY | DAYOFYEAR | DAYS | DBA | DBADM | DEC | DECIMAL | DECLARE | DEFAULT | DEFERRED | DELETE | DESC | DIAGNOSTIC | DIAGNOSTICS | DIGIT | DIGITS | DIRECTORIES | DISABLE | DISCONNECT | DISTINCT | DIVISION | DO | DOMAIN | DOUBLE | DROP
EACH | ELSE | ELSEIF | ENABLE | END | ESCAPE | EXCEPT | EXCLUSIVE | EXECUTE | EXISTS | EXIT | EXP | EXPLAIN | EXTRACT
FACTORIAL | FALSE | FETCH | FIELDPROC | FIRST | FLOAT | FLOOR | FOR | FOREACH | FOREIGN | FORWARD | FOUND | FROM | FULL | FUNCTION
GENKEY | GET | GRANT | GROUP
HANDLER | HAVING | HEX | HOLD | HOST | HOUR
IDENTIFIER | IF | IFNULL | IMMEDIATE | IN | INITCAP | INNER | INOUT | INSERT | INT | INTEGER | INTERSECT | INTERVAL | INTO | IS | ISOLATION | ISOTYPE
JOIN | JOIN_ORDER
KEEP | KEY
LAST | LATIN01 | LATIN01_UPCASE | LATIN02 | LATIN02_UPCASE | LCASE | LEADING | LEAVE | LEFT | LENGTH | LEVEL | LIKE | LIT_FALSE | LIT_TRUE | LN | LOCK | LOG | LOG10 | LONGINT | LOOP | LOWER | LTRIM
MATCH | MATERIALIZED | MAX | MEAN | MEANDEV | MEDIAN | MESSAGE_LENGTH | MESSAGE_TEXT | MICROSECOND | MIN | MINUTE | MOD | MODE | MODIFY | MONEY | MONTH | MONTHBEG | MONTHSBTWN | MORE
NAME | NEW | NOT | NULL | NULLIF | NUMBER | NUMERIC
OF | OFF | OLD | ON | ONLY | OPEN | OPTION | OR | ORDER | OUT | OUTER
PARAMETER_NAME | PASSWORD | PI | PLAN | POSITION | POSSTR | POWER | PRECISION | PRESERVE | PREVIOUS | PRIMARY | PRIVILEGES | PROCEDURE | PUBLIC
QUARTER | QUARTERBEG | QUOTED_STRING
READ | REAL | REFERENCES | REFERENCING | REFRESH | RENAME | REPEAT | RESTRICT | RETURN | RETURNED_SQLSTATE | RETURNS | REVOKE | REVOKE_GRANT_OPTION | RIGHT | ROLLBACK | ROUND | ROW | ROW_COUNT | ROUTINE | ROUTINE_NAME | ROUTINE_SCHEMA | RTRIM
SAMPLE | SAVEPOINT | SCHEMA | SCHEMA_NAME | SECOND | SELECT | SELPAREN | SERIALIZABLE | SERVER | SESSION | SET | SHARE | SHUTDOWN | SIGN | SIN | SMALLINT | SNAPSHOT | SOME | SQL | SQLEXCEPTION | SQLID | SQLWARNING | SQRT | START | STARTUP | STATEMENT | STDDEV | SUBSTR | SUBSTRING | SUM | SUMSQ | SYMMETRIC
TABLE | TABLE_NAME | TABLE_SCAN | TAN | THEN | TIME | TIMEOUT | TIMESTAMP | TIMEZONE | TIMEZONE_HOUR | TIMEZONE_MINUTE | TO | TODAY | TOP | TRAILING | TRANSACTION | TRANSACTION_ACTIVE | TRIGGER | TRIGGER_NAME | TRIGGER_SCHEMA | TRIM | TRUE | TRUNCATE
UCASE | UNDO | UNION | UNIQUE | UNKNOWN | UNLOCK | UNTIL | UPDATE | UPPER | USAGE | USER
VALUE | VALUES | VARCHAR | VARIABLE | VARIANCE | VARYING | VIEW
WEEKDAY | WEEKOFYEAR | WEEKSBTWN | WHEN | WHERE | WHILE | WITH | WORK | WRITE
YEAR | YEARBEG