Reserved Words

Reserved words are field names that cannot be used by builders when naming fields on the form.  The system reserves these words for internal use only

Here is the list:

A

ABORT

ABS

ABSENT

ABSOLUTE

ACCESS

ACCORDING

ACTION

ADA

ADD

ADMIN

AFTER

AGGREGATE

ALL

ALLOCATE

ALSO

ALTER

ALWAYS

ANALYSE

AND

ANY

AR

ARCHIVE

ARE

ARRAY

ARRAY_AGG

ARRAY_MAX_CARDINALITY

AS

ASC

ASENSITIVE

ASSERTION

ASSIGNMENT

ASYMMETRIC

AT

ATOMIC

ATTRIBUTE

ATTRIBUTES

AUTHORIZATION

AVG

BACKWARD

BASE64

BEFORE

BEGIN

BEGIN_FRAME

BEGIN_PARTITION

BERNOULLI

BETWEEN

BIGINT

BINARY

BIT

BIT_LENGTH

BLOB

BLOCKED

BOM

BOOLEAN

BOTH

BREADTH

BY

C

CACHE

CALL

CALLED

CARDINALITY

CASCADE

CASCADED

CASE

CAST

CATALOG

CATALOG_NAME

CEIL

CEILING

CHAIN

CHAR

CHAR_LENGTH

CHARACTER

CHARACTER_LENGTH

CHARACTER_SET_CATALOG

CHARACTER_SET_NAME

CHARACTER_SET_SCHEMA

CHARACTERISTICS

CHARACTERS

CHECK

CHECKPOINT

CLASS

CLASS_ORIGIN

CLOB

CLOSE

CLUSTER

COALESCE

COBOL

COLLATE

COLLATION

COLLATION_CATALOG

COLLATION_NAME

COLLATION_SCHEMA

COLLECT

COLUMN

COLUMN_NAME

COLUMNS

COMMAND_FUNCTION

COMMAND_FUNCTION_CODE

COMMENT

COMMENTS

COMMIT

COMMITTED

CONCURRENTLY

CONDITION

CONDITION_NUMBER

conf_id

CONFIGURATION

CONFLICT

CONNECT

CONNECTION

CONNECTION_NAME

CONSTRAINT

CONSTRAINT_CATALOG

CONSTRAINT_NAME

CONSTRAINT_SCHEMA

CONSTRAINTS

CONSTRUCTOR

CONTAINS

CONTENT

CONTINUE

CONTROL

CONVERSION

CONVERT

COPY

CORR

CORRESPONDING

COST

COUNT

COVAR_POP

COVAR_SAMP

CREATE

CROSS

CSV

CUBE

CUME_DIST

CURRENT

CURRENT_CATALOG

CURRENT_DATE

CURRENT_DEFAULT_TRANSFORM_GROUP

CURRENT_PATH

CURRENT_PATH

CURRENT_ROLE

CURRENT_ROW

CURRENT_SCHEMA

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TRANSFORM_GROUP_FOR_TYPE

CURRENT_USER

CURSOR

CURSOR_NAME

CYCLE

DATA

DATABASE

DATALINK

DATE

DATETIME_INTERVAL_CODE

DATETIME_INTERVAL_PRECISION

DAY

DB

dde_id

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DEFAULTS

DEFERRABLE

DEFERRED

DEFINED

DEFINER

DEGREE

DELETE

DELIMITER

DELIMITERS

DENSE_RANK

DEPENDS

DEPTH

DEREF

DERIVED

DESC

DESCRIBE

DESCRIPTOR

DETERMINISTIC

DIAGNOSTICS

DICTIONARY

DISABLE

DISCARD

DISCONNECT

DISPATCH

DISTINCT

DLNEWCOPY

DLPREVIOUSCOPY

DLURLCOMPLETE

DLURLCOMPLETEONLY

DLURLCOMPLETEWRITE

DLURLPATH

DLURLPATHONLY

DLURLPATHWRITE

DLURLPATHWRITE

DLURLSCHEME

DLURLSERVER

DLVALUE

DO

DOCUMENT

DOMAIN

DOUBLE

dp_id

DROP

DYNAMIC

DYNAMIC_FUNCTION

DYNAMIC_FUNCTION_CODE

EACH

ELEMENT

ELSE

EMPTY

ENABLE

ENCODING

ENCRYPTED

END

END_FRAME

END_PARTITION

ENFORCED

ENUM

EQUALS

err_id

ESCAPE

ev_id

EVENT

EVERY

EXCEPT

EXCEPTION

EXCLUDE

EXCLUDING

EXCLUSIVE

EXEC

EXECUTE

EXISTS

EXP

EXPLAIN

EXPRESSION

ext_id

EXTENSION

EXTERNAL

EXTRACT

FAMILY

FETCH

FILE

FILTER

FINAL

FIRST

FIRST_VALUE

FLAG

fld_id

FLOAT

FLOOR

FOLLOWING

FOR

FORCE

FOREIGN

form_id

FORM_SEQ

FORTRAN

FORWARD

FOUND

FRAME_ROW

FREE

FREEZE

FROM

FS

FULL

FUNCTION

FUNCTIONS

FUSION

G

GENERAL

GENERATED

GET

GLOBAL

GO

GOTO

GRANT

GRANTED

GREATEST

GROUP

GROUPING

GROUPS

HANDLER

HAVING

HEADER

HEX

HIERARCHY

HISTORY

HOLD

host_id

HOUR

ID

IDENTITY

IF

IGNORE

ILIKE

IMMEDIATE

IMMEDIATELY

IMMUTABLE

IMPLEMENTATION

IMPLICIT

IMPORT

IN

INCLUDING

INCREMENT

INDENT

INDEX

INDEXES

INDICATOR

INHERIT

INHERITS

INITIALLY

INLINE

INNER

INOUT

INPUT

INSENSITIVE

INSERT

INSTANCE

INSTANTIABLE

INSTEAD

INT

int_id

INTEGER

INTEGRITY

INTERSECT

INTERSECTION

INTERVAL

INTO

INVOKER

IS

ISNULL

ISOLATION

JOIN

K

KEY

KEY_MEMBER

KEY_TYPE

LABEL

LAG

LANGUAGE

LARGE

LAST

LAST_VALUE

LATERAL

LEAD

LEADING

LEAKPROOF

LEAST

LEFT

LENGTH

LEVEL

LIBRARY

LIKE

LIKE_REGEX

LIMIT

LINK

LISTEN

LN

LOAD

LOCAL

LOCALTIME

LOCALTIMESTAMP

LOCATION

LOCATOR

LOCK

LOCKED

LOGGED

LOWER

M

MAP

map_id

MAPPING

MATCH

MATCHED

MATERIALIZED

MAX

MAX_CARDINALITY

MAXVALUE

MEMBER

MERGE

MESSAGE_LENGTH

MESSAGE_OCTET_LENGTH

MESSAGE_TEXT

METHOD

MIN

MINUTE

MINVALUE

MOD

MODE

MODIFIES

MODULE

MONTH

MORE

MOVE

MULTISET

MUMPS

mv_id

NAME

NAMES

NAMESPACE

NATIONAL

NATURAL

NCHAR

NCLOB

NESTING

NEW

NEXT

NFC

NFD

NFKC

NFKD

NIL

NO

NONE

NORMALIZE

NORMALIZED

NOT

NOTHING

NOTIFY

NOTNULL

NOWAIT

nt_id

nt_seq

NTH_VALUE

NTILE

NULL

NULLABLE

NULLIF

NULLS

NUMBER

NUMERIC

OBJECT

OCCURRENCES_REGEX

OCTET_LENGTH

OCTETS

OF

OFF

OFFSET

OIDS

OLD

ON

ONLY

OPEN

OPERATOR

OPTION

OPTIONS

OR

ORDER

ORDERING

ORDINALITY

OTHERS

OUT

OUTER

OUTPUT

OVER

OVERLAPS

OVERLAY

OVERRIDING

OWNED

P

PAD

PARALLEL

PARAMETER

PARAMETER_MODE

PARAMETER_NAME

PARAMETER_ORDINAL_POSITION

PARAMETER_SPECIFIC_CATALOG

PARAMETER_SPECIFIC_NAME

PARAMETER_SPECIFIC_SCHEMA

PARSER

PARTIAL

PARTITION

PASCAL

PASSING

PASSTHROUGH

PASSWORD

PATH

PERCENT

PERCENTILE_CONT

PERCENTILE_DISC

PERIOD

PERMISSION

PLACING

PLANS

PLI

POLICY

PORTION

POSITION

POSITION_REGEX

POWER

PRECEDES

PRECEDING

PRECISION

PREPARE

PREPARED

PRESERVE

PREV

PRIMARY

PRIOR

PRIVILEGES

PROCEDURAL

PROCEDURE

PROGRAM

prot_id

PUBLIC

QUOTE

RANGE

RANK

READ

READS

REAL

REASSIGN

REC_DATE

REC_ID

REC_LAT

REC_LONG

RECHECK

RECOVERY

RECURSIVE

RED_USER

REF

REFERENCES

REFERENCING

REFRESH

REGR_AVGX

REGR_AVGY

REGR_COUNT

REGR_INTERCEPT

REGR_R2

REGR_SLOPE

REGR_SXX

REGR_SXY

REGR_SYY

REINDEX

RELATIVE

RELEASE

RENAME

REPEATABLE

REPLACE

REPLICA

REQUIRING

RESET

RESPECT

RESTART

RESTORE

RESTRICT

RESULT

RETURN

RETURNED_CARDINALITY

RETURNED_LENGTH

RETURNED_OCTET_LENGTH

RETURNED_SQLSTATE

RETURNING

RETURNS

REVOKE

RIGHT

ROLE

role_id

ROLLBACK

ROLLUP

ROUTINE

ROUTINE_CATALOG

ROUTINE_NAME

ROUTINE_SCHEMA

ROW

ROW_COUNT

ROW_NUMBER

ROWS

rpt_id

RULE

SAVEPOINT

SCALE

SCHEMA

SCHEMA_NAME

SCOPE

SCOPE_CATALOG

SCOPE_NAME

SCOPE_SCHEMA

SCROLL

sea_id

SEARCH

SECOND

SECTION

SECURITY

SELECT

SELECTIVE

SELF

SENSITIVE

SEQUENCE

SEQUENCES

SERIALIZABLE

SERVER

SERVER_NAME

SESSION

SESSION_USER

SET

SETOF

SHARE

SHOW

SIMILAR

SIMPLE

site_id

SIZE

SKIP

SMALLINT

SNAPSHOT

SOME

SOURCE

SPACE

SPECIFIC

SPECIFIC_NAME

SPECIFICTYPE

SQL

SQLCODE

SQLERROR

SQLEXCEPTION

SQLSTATE

SQLWARNING

SQRT

ss_id

st_id

STABLE

STANDALONE

START

STATE

STATEMENT

STATIC

STATISTICS

STDDEV_SAMP

STDIN

STDOUT

STORAGE

STRICT

STRIP

STRUCTURE

STYLE

sub_id

SUBCLASS_ORIGIN

SUBMIT

SUBMULTISET

SUBSTRING

SUBSTRING_REGEX

SUCCEEDS

SUM

SYMMETRIC

SYSID

SYSTEM

SYSTEM_TIME

SYSTEM_USER

T

TABLE

TABLE_NAME

TABLES

TABLESAMPLE

TABLESPACE

TEMP

TEMPLATE

TEMPORARY

TEXT

THEN

THIS

TIES

TIME

TIMESTAMP

TIMEZONE_MINUTE

TO

TOKEN

TOP_LEVEL_COUNT

TRAILING

trans_id

TRANSACTION

TRANSACTION_ACTIVE

TRANSACTIONS_COMMITTED

TRANSACTIONS_ROLLED_BACK

TRANSFORM

TRANSFORMS

TRANSLATE

TRANSLATE_REGEX

TRANSLATION

TREAT

TRIGGER

TRIGGER_CATALOG

TRIGGER_NAME

TRIGGER_SCHEMA

TRIM

TRIM_ARRAY

TRUNCATE

TRUSTED

TYPE

TYPES

UESCAPE

UNBOUNDED

UNCOMMITTED

UNDER

UNENCRYPTED

UNION

UNIQUE

UNKNOWN

UNLINK

UNLISTEN

UNLOGGED

UNNAMED

UNNEST

UNTIL

UNTYPED

UPDATE

UPPER

URI

USAGE

USER

USER_DEFINED_TYPE_CATALOG

USER_DEFINED_TYPE_CODE

USER_DEFINED_TYPE_NAME

USER_DEFINED_TYPE_SCHEMA

user_id

USING

VACUUM

VALID

VALIDATE

VALIDATOR

VALUE

VALUE_OF

VALUES

VAR_POP

VAR_SAMP

VARBINARY

VARCHAR

VARYING

vee_id

VERBOSE

VERSION

VERSIONING

VIEW

VIEWS

VOLATILE

WHEN

WHENEVER

WHERE

WHITESPACE

WIDTH_BUCKET

WINDOW

WITH

WITHIN

WITHOUT

WORK

WRAPPER

WRITE

XML

XMLAGG

XMLATTRIBUTES

XMLBINARY

XMLCAST

XMLCOMMENT

XMLCONCAT

XMLDECLARATION

XMLDOCUMENT

XMLELEMENT

XMLEXISTS

XMLFOREST

XMLITERATE

XMLNAMESPACES

XMLPARSE

XMLPI

XMLQUERY

XMLROOT

XMLSCHEMA

XMLSERIALIZE

XMLTABLE

XMLTEXT

XMLVALIDATE

YEAR

YES

ZONE

Related articles