Summary
This article covers all of the reserved words for field names that cannot be used
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.
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 |
Need more help?
Please visit the Datatrak Contact Information page.