Advantage SQL Engine
The following keywords are reserved by the Advantage SQL engine and cannot be used as identifiers in SQL statements unless they are enclosed in double quotes or [] brackets. For example, SELECT "user" FROM test. Note that this is the current list and will probably expand in the future as functionality is added.
To retrieve a list of reserved keywords from the Advantage SQL Engine call the system procedure, sp_GetSQLKeywords.
|
ADD |
EXECUTE |
ORDER |
|
ALL |
EXISTS |
OUTER |
|
ALTER |
FALSE |
OUTPUT |
|
AND |
FETCH |
PRIMARY |
|
ANY |
FROM |
PROCEDURE |
|
AS |
FULL |
RETURN |
|
ASC |
FUNCTION |
REVOKE |
|
AT |
GRANT |
RIGHT |
|
AVG |
GROUP |
ROLLBACK |
|
BEGIN |
HAVING |
SAVEPOINT |
|
BETWEEN |
IN |
SELECT |
|
BY |
INDEX |
SET |
|
CASE |
INNER |
SQL |
|
CAST |
INSERT |
SUM |
|
CLOSE |
INTO |
TABLE |
|
COLUMN |
IS |
THEN |
|
COMMIT |
JOIN |
TO |
|
CONSTRAINT |
KEY |
TRANSACTION |
|
CONVERT |
LEFT |
TRIGGER |
|
COUNT |
LIKE |
TRUE |
|
CREATE |
MATCHED |
UNION |
|
CURSOR |
MAX |
UNIQUE |
|
DECLARE |
MERGE |
UPDATE |
|
DEFAULT |
MIN |
USER |
|
DELETE |
NOT |
USING |
|
DESC |
NULL |
VALUES |
|
DISTINCT |
OF |
VARCHAR |
|
DROP |
ON |
VIEW |
|
ELSE |
OPEN |
WHEN |
|
END |
OR |
WHERE |
|
ESCAPE |
RETURNS |
WORK |