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.