Identifying Field Names That Cannot be Used when Naming Fields. The system reserves these words for internal use only
The system reserves the following 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 |