In the ObjectServer, certain words are reserved as SQL
or ObjectServer keywords.
You are not allowed to use reserved words as object names
in ObjectServer SQL. The reserved words are listed alphabetically
in the following tables.
A to E
Table 1. A to E| A |
B |
C |
D |
E |
|---|
| ACTCMD |
BACKUP |
CACHE |
DATABASE |
EACH |
| ADD |
BEFORE |
CALL |
DATE[TIME] |
EDGE |
| AFTER |
BEGIN |
CANCEL |
DEBUG |
ELSE |
| ALL |
BETWEEN |
CASE |
DEC[EMBER] |
ELSEIF |
| ALTER |
BIDIRECTIONAL |
CHAR[ACTER] |
DECLARE |
EMPTY |
| AND |
BINARY |
CHECK |
DEFERRED |
END |
| ANY |
BIND |
CHECKPOINTING |
DELAYED |
ENCRYPTED |
| APR[IL] |
BOOL[EAN] |
COLUMN |
DELETE |
EVALUATE |
| ARGUMENTS |
BREAK |
COMMENT |
DESC |
EVENT |
| ARRAY |
BY |
COMMIT |
DESCENT |
EVERY |
| AS |
|
CONN[ECTION] |
DESCRIBE |
EVTFT |
| ASC |
|
COUNT |
DETACHED |
EXECUTABLE |
| ASSIGN |
|
CREATE |
DISABLE |
EXEC[UTE] |
| AUG[UST] |
|
CURRENT |
DIST |
EXTENSION |
| AUTHORIZE | AUTHORISE |
|
|
DISTINCT |
EXTERNAL |
| AVERAGE | AVG |
|
|
DO |
|
| |
|
|
DOUBLE |
|
| |
|
|
DROP |
|
F to J
Table 2. F to J| F |
G |
H |
I |
J |
|---|
| FALSE |
GET |
HARD |
ID |
JAN[UARY] |
| FANP |
GETIDUC |
HAVING |
IDUC |
JOIN |
| FEB[RUARY] |
GRANT |
HIDDEN |
IF |
JUL[Y] |
| FILE |
GROUP |
HOST |
IMMEDIATE |
JUN[E] |
| FILTER |
|
HOURS |
IN |
|
| FLUSH |
|
|
INCLUDING |
|
| FOR |
|
|
INCR |
|
| FORMAT |
|
|
INCREMENT |
|
| FRI[DAY] |
|
|
INITIAL |
|
| FROM |
|
|
INSERT |
|
| FULL |
|
|
INT[EGER] |
|
| |
|
|
INT[EGER]64 |
|
| |
|
|
INTO |
|
| |
|
|
ISQL |
|
L to P (no reserved words begin with K)
Table 3. L to P (no reserved words begin with K)| L |
M |
N |
O |
P |
|---|
| LEAVE |
MAR[CH] |
NAMING |
OCT[OBER] |
PAM |
| LIKE |
MAX |
NEXT |
OF |
PASSWORD |
| LIMIT |
MAXFILES |
NO |
ON |
PERSISTENT |
| LINK |
MAXSIZE |
NODEFAULT |
ONCE |
PRIMARY |
| LOAD |
MAY |
NOMODIFY |
ONLY |
PRIORITY |
| LOCK[PH] |
MEMSTORE |
NOT |
OPTION |
PRIVILEGE |
| LOGIN |
MESSAGE |
NOTIFY |
OR |
PROCEDURE |
| |
METRIC |
NOV[EMBER] |
ORDER |
PROP[S] |
| |
MIN |
|
OUT |
PROTECT |
| |
MINUTES |
|
|
PUBLISH |
| |
MON[DAY] |
|
|
|
Q to U
Table 4. Q to U| Q |
R |
S |
T |
U |
|---|
| QUERY |
RAISE |
SAT[URDAY] |
TABLE |
UNIDIRECTIONAL |
| |
REAL |
SAVE |
TEMPORAL |
UNION |
| |
REGISTER |
SECONDS |
TEMP[ORARY] |
UNIQUE |
| |
REINSERT |
SELECT |
THEN |
UNLOAD |
| |
REMOVE |
SELF |
THU[RSDAY] |
UNREGISTER |
| |
REPLACE |
SEND |
TIME |
UNSIGNED |
| |
RESTRICTION |
SEP[TEMBER] |
TO |
UNSIGNED64 |
| |
RESYNC |
SESSION |
TOKEN |
UNSUBSCRIBE |
| |
RETRY |
SET |
TOP |
UNTIL |
| |
REVOKE |
SHORT |
TRANS[ACTION] |
UPDATE |
| |
ROLE |
SHOW |
TRANSIENT |
UPDATING |
| |
ROW |
SIGNAL |
TRIGGER |
USE |
| |
ROWOF |
SKIP |
TRUE |
USER |
| |
|
SNDMSG |
TRUNCATE |
UTC |
| |
|
SOFT |
TUE[SDAY] |
|
| |
|
SQL |
TYPEOF |
|
| |
|
STATEMENT |
|
|
| |
|
STORE |
|
|
| |
|
SUBSCRIBE |
|
|
| |
|
SUM |
|
|
| |
|
SUN[DAY] |
|
|
| |
|
SVC |
|
|
| |
|
SYNC |
|
|
| |
|
SYSTEM |
|
|
V to Y (no reserved words begin with Z)
Table 5. V to Y (no reserved words begin with Z)| V |
W |
X |
Y |
|---|
| VALUES |
WAIT |
XST |
YES |
| VARCHAR[ACTER] |
WED[NESDAY] |
|
|
| VERBOSE |
WHEN |
|
|
| VIA |
WHERE |
|
|
| VIEW |
WIDTH |
|
|
| VIRTUAL |
WITH |
|
|
| |
WORK |
|
|
| |
WRITE |
|
|