R:BASE Reserved Word List     
 
The following is a list of all known reserved words, commands, keywords, and other names that are in effect when ANSI is set on, which is the default setting. These words, commands, keywords, and other names are to be used exclusively by the R:BASE database.  
 
Do not use these words or any shorter forms of them as names for columns, tables, or views. As a rule, if the word is a reserved word, R:BASE will flag it. For example in RBDefine, R:BASE will not allow you to use a reserved word as a Column or Table name. However this MAY NOT always the case. For example while in RBDefine, R:BASE may not warn you about REF, short for REFERENCES, but REF will not be allowed in a command. If a particular Column or Table is giving you problems, please check out the list below and consider all shortened versions of the words listed here.  
 
Names used by System tables, System views and System columns are also reserved words. As a rule, all words beginning with "SYS" are reserved.  
 
ABORT  
ABS  
ABSOLUTE  
ACOS  
ADA  
ADD  
AINT  
ALL  
ALTER  
AND  
ANINT  
ANSI  
ANY  
APPEND  
AS  
ASC  
ASCII  
ASIN  
ASSIGN  
AT  
ATAN  
ATAN2  
ATT  
ATTACH  
AUTHORIZATION  
AUTHORIZE  
AUTOCHK  
AUTOCOMMIT  
AUTOCONVERT  
AUTODROP  
AUTONUM  
AUTONUMBER  
AUTORECOVER  
AUTOROWVER  
AUTOSKIP  
AUTOSYNC  
AUTOUPGRADE  
AVERAGE  
AVG  
BACKGRND  
BACKUP  
BEEP  
BEGIN  
BEGINS  
BELL  
BETWEEN  
BIT  
BITNOTE  
BLINK  
BLINKING  
BOTH  
BREAK  
BRND  
BROWSE  
BUILD  
BY  
C  
CALL  
CASCADE  
CASE  
CASEP  
CD  
CGA  
CENTURY  
CHANGE  
CHAR  
CHARACTER  
CHDIR  
CHDRV  
CHECK  
CHKDSK  
CHKKEY  
CHOOSE  
CLEAR  
CLOSE  
CLS  
COBOL  
CODELOCK  
COLLATE  
COLLATEC  
COLOR  
COLUMN  
COLUMNS  
COMMENT  
COMMIT  
COMPUTE  
COMPUTED  
CONNECT  
CONSTRAINT  
CONTAINS  
CONTINUE  
COPY  
COS  
COSH  
COUNT  
CREATE  
CROSSTAB  
CTR  
CTXT  
CURRENCY  
CURRENT  
CURSOR  
CURSORS  
CVAL  
DAT  
DATA  
DATE  
DATETIME  
DEBUG  
DECIMAL  
DECLARE  
DEFAULT  
DEFINE  
DELETE  
DESC  
DETACH  
DEXTRACT  
DIALOG  
DIM  
DIR  
DISCONNECT  
DISPLAY  
DISTINCT  
DOUBLE  
DRAW  
DROP  
DUPLICAT  
DUPLICATE  
ECHO  
EDIT  
EDITOR  
ELSE  
END  
ENDC  
ENDIF  
ENDS  
ENDSW  
ENDWHILE  
ENTER  
ENVVAL  
EQ  
EQNULL  
ERASE  
ERROR  
ESC  
ESCAPE  
EXCEPT  
EXECUTE  
EXISTS  
EXIT  
EXP  
EXPAND  
EXPLODE  
EXPRESS  
FAILS  
FASTFK  
FASTLOCK  
FEEDBACK  
FETCH  
FILES  
FILL  
FILLIN  
FIRST  
FLOAT  
FLUSH  
FOLD  
FOR  
FOREGRND  
FOREIGN  
FORMAT  
FORMATTED  
FORMS  
FORTRAN  
FOUND  
FROM  
FULL  
FV1  
FV2  
GATEWAY  
GE  
GET  
GETDATE  
GETKEY  
GETVAL  
GO  
GOTO  
GRANT  
GROUPED  
GT  
HAVING  
HEADING  
HEADINGS  
HELP  
ICAP1  
ICAP2  
ICHAR  
IDAY  
IDWK  
IF  
IFEQ  
IFGT  
IFLT  
IFRC  
IHASH  
IHR  
IMIN  
IMON  
IN  
INDEX  
INDICATOR  
INI  
INITPOS  
INPUT  
INSERT  
INT  
INTEGER  
INTENSITY  
INTERSECT  
INTERVAL  
INTO  
IS  
ISEC  
ISTAT  
IYR  
IYR4  
JDATE  
JOIN  
KEY  
KEYBOARD  
KEYMAP  
LABEL  
LANGUAGE  
LAST  
LASTKEY  
LAUNCH  
LAVG  
LAYOUT  
LBLPRINT  
LCFOLD  
LE  
LIKE  
LIMIT  
LINEEND  
LINES  
LIST  
LISTATT  
LISTREL  
LJS  
LMAX  
LMIN  
LOAD  
LOCK  
LOG  
LOG10  
LOOKUP  
LOOKUPS  
LT  
LUC  
MANOPT  
MAX  
MAXIMUM  
MAXTRANS  
MD  
MENU  
MESSAGES  
MIN  
MINIMUM  
MKDIR  
MOD  
MODULE  
MOUSE  
MOVE  
MPW  
MULTI  
NAME  
NE  
NEW  
NEWPAGE  
NEWROW  
NEXT  
NEXTROW  
NEXTTAB  
NINT  
NOCHECK  
NOECHO  
NOFILL  
NOHEADER  
NONE  
NONUM  
NOT  
NOTE  
NOTE_PAD  
NULL  
NUM  
NUMERIC  
OF  
OFF  
ON  
OPEN  
OPTION  
OPTIONS  
OR  
ORDER  
OUTER  
OUTPUT  
OWNER  
PACK  
PAGE  
PAGEMODE  
PAGEROW  
PASCAL  
PASSTAB  
PASSTHROUGH  
PAUSE  
PLAYBACK  
PLI  
PLUGINS  
PMT1  
PMT2  
POINTER  
PRECISION  
PREF  
PREFIX  
PREVROW  
PREVTAB  
PRIMARY  
PRINT  
PRINTER  
PRIOR  
PRIVILEGE  
PRNSETUP  
PROC  
PROCEDURE  
PROJECT  
PROMPT  
PROMPTS  
PROPERTY  
PUBLIC  
PUT  
PV1  
PV2  
QBE  
QUALCOLS  
QUERY  
QUIT  
RATE1  
RATE2  
RATE3  
RBAPP  
RBBEDIT  
RBDEFINE  
RBEDIT  
RBGSIZE  
RBLABELS  
RBSYNC  
RBSYSTEM  
RD  
RDATE  
READ  
READ/WRITE  
REAL  
RECALC  
RECORD  
RED  
REDEFINE  
REFERENCES  
REFRESH  
RELATIVE  
RELOAD  
REMOVE  
RENAME  
REPORTS  
RESET  
RESTORE  
RETURN  
REVERSE  
REVOKE  
RHIDE  
RJS  
RMDIR  
ROLLBACK  
ROUND  
ROW  
ROWLOCKS  
RPHONE  
RPW  
RSHOW  
RTIME  
RULES  
RUN  
SATTACH  
SAVEROW  
SCHEMA  
SCONNECT  
SCRATCH  
SCREEN  
SCROLL  
SDETACH  
SECTION  
SELECT  
SELMARGIN  
SEQUENCE  
SERVER  
SET  
SFIL  
SGET  
SHOW  
SIGN  
SIN  
SINH  
SKIP  
SLEN  
SLOC  
SMALLINT  
SMOVE  
SNAP  
SOME  
SORT  
SORTED  
SOUNDS  
SOUNDS_L  
SOUNDS_LIKE  
SPUT  
SQLCODE  
SQLERROR  
SQRT  
SRPL  
SSQL  
SSUB  
STARTUP  
STATICDB  
STDEV  
STORE  
STRIM  
STRUCTURE  
SUB  
SUBTRACT  
SUFFIX  
SUM  
SWITCH  
SYS  
TABLE  
TABLES  
TABSIZE  
TALLY  
TAN  
TANH  
TDWK  
TERM1  
TERM2  
TERM3  
TERMINAL  
TEXT  
TEXTRACT  
TIME  
TIMEOUT  
TITLE  
TMON  
TO  
TOLERANCE  
TRACE  
TRANSACT  
TRIG  
TYPE  
UDF  
ULC  
UNION  
UNIQUE  
UNLOAD  
UNNAMED  
UPDATE  
UPGRADE  
USER  
USERAPP  
USING  
VALUES  
VARBIT  
VARCHAR  
VARIABLE  
VARIANCE  
VERIFY  
VERSION  
VIEW  
VIEWS  
WAIT  
WALKMENU  
WHENEVER  
WHERE  
WHILE  
WHILEOPT  
WIDTH  
WITH  
WORK  
WRAP  
WRITE  
YEAR  
ZERO  
ZIP