RESERVED Words
What is a reserved word?
A reserved word is any word SQL uses to perform operations on the database. Examples are: LIKE, SELECT, FROM, WHERE, IN, DATE, etc...
Do not use these words as database names, table names, field names, etc...
Here is a partial list of reserved words. Check your database documentation for a more complete list.
ADDCOL
AGGREGAT
ALL
ALTER
AS
ASC
ATTACH
ATTRIBUTE
AUTO
AUTODISP
BACK
BACKWARD
BATCH
BL
BLANKS
BLKSIZE
BLOCKS
BOLD
BR
BREAK
BT
BUFFERS
BUFNO
BUT
BY
BYE
CALL
CASE
CASELESS
CASELIM
CATALOG
CATEGORICAL CENTER
CHARACTER
CLEAR
CLIM
CLR
CMD
CMDINCR
CMPTRIM
CMPUPPER
COL
COLHEAD
COLUMNS
COM
COMMANDS
CONTINUE
CONTROLS
CREATE
CTR
DATABASE
DATE
DATEC
DB
DBA
DBL
DBMS
DEBUG
DEC
DECIMAL
DECSIGN
DELCOL
DELETE
DESC
DET
DETAIL
DIFF
DISCONNECT
DISPLAY
DIST
DISTINCT
DOUBLE
DPL
DPLACES
DROP
DTL
ECHO
EDIT
EJECT
ENTER
ERASE
ESCAPE
EXCEPT
EXCL
EXEC
EXPERT
EXPONENT
EXPORT
FAM
FAMILY
FILENAME
FILES
FILL
FIRST
FIXED
FLOAT
FMT
FOOT
FOOTING
FOR
FORMAT
FROM
GET
GRANT
GROUP
GROUPING
GRP
GRPSIZE
HAVING
HCTR
HEAD
HEADCENT
HEADCTR
HEADING
HOLD
HOST
IN
INCL
INCLUDE
INDENT
INDEX
INDICES
INPUT
INSERT
INTEGER
INTER
INTO
JOURNAL
L
LAB
LABEL
LAST
LC
LEFT
LIMITS
LININCR
LIST
LNEGSIGN
LOCAL
LOG
LOWER
LOWERCASE
LPOS
LPOSSIGN
LRECL
MAX
MAXIMUM
MEM
MEMBER
MEMORY
MINIMUM
MISS
MISSCHAR
MISSING
MOD
MODCOL
MODES
MODHIST
MODIFY
MODS
MONITOR
NAME
NEG
NOCOUNTS
NOLABELS
NOSECURITY
NOTABFILE
NOTNULL
NOVICE
NOWAIT
NOWORKSPACE NULL
NUMERIC
OBSERVATION
OFF
ON
ONLY
ORDER
OUT
OUTER
OUTLINE
OUTPUT
P
PAGE
PAGEHEAD
PAGELIM
PAGES
PAGESIZE
PAGING
PASSWORD
PATH
PATHLESS
PATHS
PCTFREE
PERMHIST
PG
PGH
PGHEAD
PGLIM
PGS
PGSIZE
PREFIX
PRESET
PRINT
PROC
PROCEDURE
PROCS
PROMPT
PS
PW
R
READ
REAL
RECALL
RECCOUNT
RECFM
RECLIM
RECSIZE
RELATION
REM
REMARKS
RENAME
REPORTS
REV
REVERSE
REVOKE
RIGHT
RLIM
RT
SAMPLE
SAVE
SCALE
SCR
SCRATCH
SCREEN
SECURITY
SEL
SELECT
SELLIM
SEP
SEPARATE
SEPARATOR
SET
SETTING
SGL
SHOW
SINGLE
SLIM
SMALLINT
SORT
SPACE
SPACEC
SPACED
SPACES
SPACET
SPARSE
SPLIT
SPSS
SRLEN
SRTSIZE
START
STATS
STORE
STOT
STRUCTURE
SUBFILE
SUBTOTAL
SUPPRESS
SYN
SYNONYMS
SYNS
SYSTABS
T
TAB
TABFILE
TABLE
TABSIZE
TEXCLUDE
TF
THOUSAND
THOUSIGN
TIME
TIMEC
TINYINT
TNEG
TNEGSIGN
TO
TOTALS
TPL
TPOS
TPOSSIGN
TREE
TRIPLE
TT
TTITLE
UC
UCOL
UHEAD
UNDCOL
UNDEFINE
UNDERCOL
UNDERHEAD
UNDHEAD
UNION
UNIQUE
UNQ
UPDATE
UPPER
UPPERCAS
USING
USRTSIZ
VALLAB
VALUES
VARCHAR
VARIABLE
VCHR
VIA
VIEW
VOL
VOLUME
WEIGHT
WHERE
WIDTH
WORK
WRAP
WRITE
X
ZERO
|