Reserved Words

10 Nov 1995 updated



The following list of words are each reserved in some database context; e.g., operating system command, data base object. This list was culled from a number of sources and is not represented as complete or accurate for any particular environment. There may be no conflict in your target environment. But it is prudent to check.

For example, it is very unwise to name any database object (e.g., a table, column, view, index) "GROUP". This can make SQL very unhappy!

Click the capital key letter at the head of any alpha section to return here from the reserved word list.


A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

ABORT
ABS
ABSOLUTE
ACCEPT
ACCES
ACTIVATE
ADD
ADDFORM
AFTER
ALL
ALTER
AND
ANDFILENAME
ANY
ANYFINISH
APPEND
ARCHIVE
ARRAY
AS
ASC
ASCENDING
ASCII
ASSERT
ASSIGN
AT
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHORIZATION
AUTONEXT
AVERAGE
AVG
AVGU


B

BACKOUT
BEFORE
BEGIN
BEGINLOAD
BEGINMODIFY
BEGINNING
BEGWORK
BETWEEN
BETWEENBY
BORDER
BOTTOM
BREAK
BREAKDISPLAY
BROWSE
BUFERED
BUFFER
BUFFERED
BULK
BY
BYTE


C

CALL
CANCEL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
CHAR_CONVERT
CHECK
CHECKPOINT
CHR2FL
CHR2FLO
CHR2FLOA
CHR2FLOAT
CHR2INT
CLEAR
CLEARROW
CLIPPED
CLOSE
CLUSTER
CLUSTERED
CLUSTERING
COBOL
COLD
COLUMN
COLUMNS
COMMAND
COMMENT
COMMIT
COMMITTED
COMPRESS
COMPUTE
CONCAT
COND
CONFIG
CONFIRM
CONNECT
CONSTRAINT
CONSTRUCT
CONTAIN
CONTAINS
CONTINUE
CONTROLROW
CONVERT
COPY
COUNT
COUNTU
COUNTUCREATE
CRASH
CREATE
CURRENT
CURSOR


D

DATA
DATABASE
DATAPAGES
DATABASE
DATA_PGS
DATE
DAY
DAYNUM
DBA
DBCC
DBE
DBEFILE
DBEFILEO
DBEFILESET
DBSPACE
DBYTE
DEC
DECENDING
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFER
DEFINE
DEFINITION
DELETE
DELETEROW
DESC
DESCENDING
DESCENDNG
DESCRIBE
DESCRIPTOR
DESTPOS
DESTROY
DEVICE
DEVSPACE
DIRECT
DIRTY
DISCONNECT
DISK
DISPLACE
DISPLAY
DISTINCT
DISTRIBUTION
DIV
DO
DOES
DOMAIN
DOUBLE
DOWN
DROP
DUAL
DUMMY
DUMP
DUPLICATES


E

EACH
EBCDIC
EDITADD
EDITUPDATE
ED_STRING
ELSE
ELSEIF
END
ENDDATA
ENDDISPLAY
ENDFORMS
ENDIF
ENDING
ENDLOAD
ENDLOOP
ENDMODIFY
ENDPOS
ENDRETRIEVE
ENDSELECT
ENDWHILE
END_ERROR
END_FETCH
END_FOR
END_GET
END_MODIFY
END_PLACE
END_SEGMENT_S
END_SEGMENT_STRING
END_STORE
END_STREAM
EQ
ERASE
ERROR
ERRLVL
ERROREXIT
EVALUATE
EVALUATING
EVERY
EXCEPT
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXPLICIT
EXTENT
EXTERNAL


F

FALSE
FETCH
FIELD
FILE
FILENAME
FILLFACTOR
FINALISE
FINALIZE
FINDSTR
FINISH
FIRST
FIRSTPOS
FIXED
FL
FLOAT
FLUSH
FOR
FOREACH
FORMAT
FORMDATA
FORMINIT
FORMS
FORTRAN
FOUND
FRANT
FRAPHIC
FREE
FROM
FRS
FUNCTION


G

GE
GET
GETFORM
GETOPER
GETROW
GLOBAL
GLOBALS
GO
GOTO
GRANT
GRAPHIC
GROUP
GT


H

HAVING
HEADER
HELP
HELPFILE
HELP_FRS
HOLD
HOLDLOCK


I

IDENTIFIED
IDENTIFIELD
IF
IFDEF
IGNORE
IMAGE
IMMEDIATE
IMMIDIATE
IMPLICIT
IN
INCLUDE
INCREMENT
INDEX
INDEXED
INDEXNAME
INDEXPAGES
INDICATOR
INFIELD
INFO
INGRES
INIT
INITIAL
INITIALISE
INITIALIZE
INITTABLE
INPUT
INQUIRE_EQUEL
INQUIRE_FRS
INQUIRE_INGRES
INQUIR_FRS
INSERT
INSERTROW
INSTRUCTIONS
INT
INT2CHR
INTEGER
INTEGRITY
INTERESECT
INTERRUPT
INTERSECT
INTO
INTSCHR
INVOKE
IS
ISAM
ISOLATION


J

JOURNALING


K

KEY
KILL


L

LABEL
LANGUAGE
LAST
LASTPOS
LE
LEFT
LENGTH
LENSTR
LET
LEVEL
LIKE
LIKEPROCEDURETP
LINE
LINENO
LINES
LINK
LIST
LOAD
LOADTABLE
LOADTABLERESUME
LOCAL
LOCATION
LOCK
LOCKING
LOG
LONG
LOWER
LPAD
LT


M

MAIN
MANUITEM
MARGIN
MATCHES
MATCHING
MAX
MAXEXTENTS
MAXPUBLICUNION
MAXRECLEN
MDY
MENU
MENUITEM
MENUITEMSCREEN
MESSAGE
MESSAGERELOCATE
MESSAGESCROLL
MFETCH
MIN
MINRECLEN
MINRETURNUNTIL
MINUS
MIRROREXIT
MISSING
MIXED
MOD
MODE
MODIFY
MODIFYREVOKEUPDAT
E
MODULE
MONEY
MONITOR
MONTH
MOVE
MULTI


N

NAME
NE
NEED
NEW
NEWLOG
NEXT
NEXTSCROLLDOWN
NO
NOAUDIT
NOCOMPRESS
NOCR
NOJOURNALING
NOLIST
NOLOG
NONCLUSTERED
NORMAL
NOSYSSORT
NOT
NOTFFOUND
NOTFOUND
NOTRANS
NOTRIM
NOTRIMSCROLLUP
NOTROLLBACKUSER
NOWAIT
NULL
NULLIFY
NULLSAVEUSING
NULLVAL
NUMBER
NUMERIC
NXFIELD


O

OF
OFF
OFFLINE
OFSAVEPOINTVALUES
OFFSETS
OLD
ON
ONCE
ONLINE
ONSELECTWHERE
ONTO
OPEN
OPENSETWHILE
OPENSLEEP
OPTIMIZE
OPTION
OPTIONS
OR
ORDER
ORDERSQLWORK
ORSOMEWITH
ORSORT
OTHERWISE
OUT
OUTER
OUTPUT
OUTPUT PAGE
OUTSTOP
OVER
OWNER
OWNERSHIP


P

PAGE
PAGENO
PAGES
PARAM
PARTITION
PASCAL
PASSWORD
PATHNAME
PATTERN
PAUSE
PCTFREE
PERCENT
PERM
PERMANENT
PERMIT
PERMITSUM
PIPE
PLACE
PLAN
PLI
POS
POWER
PRECISION
PREPARE
PREPARETABLE
PRESERVE
PREV
PREVIOUS
PREVISION
PRINT
PRINTER
PRINTSCREEN
PRINTSCREENSCROLL
PRINTSUBMENU
PRINTSUMU
PRIOR
PRIV
PRIVATE
PRIVILAGES
PRIVILAGESTHEN
PRIVILEGES
PROC
PROCEDURE
PROCESSEXIT
PROGRAM
PROGUSAGE
PROMPT
PROMPTSCROLLDOWN
PROMPTTABLEDATA
PROTECT
PSECT
PUBLIC
PUBLICREAD
PUT
PUTFORM
PUTFORMSCROLLUP
PUTFORMUNLOADTAB
LE
PUTOPER
PUTOPERSLEEP
PUTROW
PUTROWSUBMENU
PUTROWUP


Q

QUERY
QUICK
QUIT


R

RAISERROR
RANGE
RANGETO
RAW
RDB$DB_KEY
RDB$LENGTH
RDB$MISSING
RDB$VALUE
RDB4DB_KEY
RDB4LENGTH
RDB4MISSING
RDB4VALUE
READ
READONLY
READPASS
READTEXT
READWRITE
READY
READ_ONLY
READ_WRITE
REAL
RECONFIGURE
RECONNECT
RECORD
RECOVER
REDISPLAY
REDISPLAYTABLEDATA
REDISPLAYVALIDATE
REDUCED
REGISTER
REGISTERUNLOADDATA
REGISTERVALIDROW
REJECT
RELATIVE
RELEASE
RELOAD
RELOCATE
RELOCATEUNIQUE
REMOVE
REMOVEUPRELOCATEV
REMOVEVALIDATE
REMOVEWHENEVER
RENAME
REPEAT
REPEATABLE
REPEATED
REPEATVALIDROW
REPLACE
REPLACEUNTIL
REPLSTR
REPORT
REQUEST_HANDLE
RESERVED_PGS
RESERVING
RESET
RESOURCE
REST
RESTART
RESTORE
RESTRICT
RESUME
RETRIEVE
RETRIEVEUPDATE
RETURN
RETURNING
REVOKE
RIGHT
ROLLBACK
ROLLFORWARD
ROLOLBACK
ROUND
ROW
ROWCNT
ROWCOUNT
ROWID
ROWNUM
ROWS
RPAD
RULE
RUN
RUNTIME


S

SAMPLSTDEV
SAVE
SAVEPOINT
SAVEPOINTWHERE
SAVEVIEW
SCHEMA
SCOPE
SCREEN
SCROLL
SCROLLDOWN
SCROLLUP
SEARCH
SEGMENT
SEL
SELE
SELEC
SELECT
SELUPD
SERIAL
SESSION
SET
SETWITH
SET_EQUEL
SET_FRS
SET_INGRES
SETUSER
SHARE
SHARED
SHORT
SHOW
SHUTDOWN
SIZE
SKIP
SLEEP
SMALLFLOAT
SMALLINT
SOME
SORT
SORTERD
SOUNDS
SOURCEPOS
SPACE
SPACES
SQL
SQLCODE
SQLDA
SQLERROR
SQLEXEPTION
SQLEXPLAIN
SQLNOTFOUND
SQRT
STABILITY
START
STARTING
STARTPOS
START_SEGMENT
START_SEGMENTED_?
START_STREAM
START_TRANSACTION
STATE
STATISTICS
STDEV
STEP
STOP
STORE
STRING
SUBMENU
SUBSTR
SUCCESFULL
SUCCESSFULL
SUM
SUMU
SUPERDBA
SYB_TERMINATE
SYNONYM
SYSDATE
SYSSORT


T

TABLE
TABLEDATA
TEMP
TEMPORARY
TERMINATE
TEXT
TEXTSIZE
THEN
THROUGH
THRU
TID
TIME
TO
TODAY
TOLOWER
TOP
TOTAL
TOUPPER
TP
TRAILER
TRAN
TRANS
TRANSACTION
TRANSACTION_HANDLE
TRANSFER
TRIGGER
TRING
TRUE
TRUNC
TRUNCATE
TSEQUAL
TYPE


U

UID
UNBUFFERED
UNION
UNIQUE
UNLOAD
UNLOADDATA
UNLOADTABLE
UNLOCK
UNTIL
UP
UPDATE
UPPER
USAGE
USE
USED_PGS
USER
USING


V

VALIDATE
VALIDROW
VALUES
VARC
VARCH
VARCHA
VARCHAR
VARGRAPHIC
VERB_TIME
VERIFY
VERSION
VIEW


W

WAIT
WAITFOR
WAITING
WARNING
WEEKDAY
WHEN
WHENEVER
WHERE
WHILE
WINDOW
WITH
WITHOUT
WORK
WRAP
WRITE
WRITEPASS
WRITETEXT


X


Y

YEAR


Z


Where to go from here:


Copyright © 1996 Applied Information Science International