Reserved Keywords List of Databases

When creating tables (such as attribute tables, datasets) and fields in SuperMap, there are certain restrictions on the names of fields and datasets:

  • Names should consist of Chinese characters, letters, numbers, and underscores, but cannot start with numbers, underscores, or "sm". "sm" is a reserved keyword for system default fields in UDB engine.

    Note: Creating fields starting with "sm" is prohibited, but datasets starting with "sm" are allowed.

  • Name length cannot be 0 or exceed 30 bytes (i.e., 30 English letters or 15 Chinese characters).
  • No special characters are allowed except numbers, letters, Chinese characters, and underscores (e.g., spaces, parentheses).
  • Must not conflict with reserved fields of respective databases.

Databases like UDB, Oracle, and SQL Server have reserved keywords. When creating tables and fields in SuperMap, these keywords cannot be used as table or field names. This document lists reserved keywords for UDB and Oracle databases for user reference. In addition to the listed keywords, Oracle automatically prefixes system-generated objects and subobjects with "SYS_", thus users should avoid using "SYS_" prefix to prevent naming conflicts.

Reserved Keywords of UDB Databases

ABORT CAST DETACH HAVING LIKE QUERY TO
ACTION CHECK DISTINCT IF LIMIT RAISE THEN
ADD COLLATE DROP IGNORE LINES REFERENCES TRANSACTION
AFTER COLUMN EACH IMMEDIATE MATCH REGEXP TRIGGER
ALL COMMIT ELSE IN NATURAL REINDEX UNION
ALTER CONFLICT END INDEX NO RELEASE UNIQUE
ANALYZE CONSTRAINT ESCAPE INDEXED NOT RENAME UPDATE
AND CREATE EXCEPT INITIALLY NOTNULL REPLACE USING
AS CROSS EXCLUSIVE INNER NULL RESTRICT VACUUM
ASC CURRENT_DATE EXISTS INSERT OF RIGHT VALUES
ATTACH CURRENT_TIME EXPLAIN INSTEAD OFFSET ROLLBACK VIEW
AUTOINCREMENT CURRENT_TIMESTAMP FAIL INTERSECT ON ROW VIRTUAL
BEFORE DATABASE FOR INTO OR SAVEPOINT WHEN
BEGIN DEFAULT FOREIGN IS ORDER SELECT WHERE
BETWEEN DEFERRABLE FROM ISNULL OUTER SET  
BY DEFERRED FULL JOIN PLAN TABLE  
CASCADE DELETE GLOB KEY PRAGMA TEMP  
CASE DESC GROUP LEFT PRIMARY TEMPORARY  

Reserved Keywords of Oracle Database

ABORT COMMIT EXIT LIMITED OTHERS ROWNUM TEXT
ACCEPT COMPRESS FALSE LINES OUT ROWS THEN
ACCESS CONNECT FETCH LOCK PACKAGE ROWTYPE TO
ADD CONSTANT FILE LONG PARTITION RUN TRIGGER
ALL CRASH FLOAT LOOP PCTFREE SAVEPOINT TRUE
ALTER CREATE FOR MAX PLS_INTEGER SCHEMA TYPE
AND CURRENT FROM MAXEXTENTS POSITIVE SELECT UID
ANY CURRVAL MINUS MIN POSITIVEN SEPARATE UNION
ARRAY CURSOR FUNCTION MLSLABEL PRAGMA SESSION UNIQUE
ARRAYLEN DATABASE GENERIC MOD PRIOR SET UPDATE
AS DATA_BASE GOTO MODE PRIVATE SHARE USE
ASC DATE GRANT MODIFY PRIVILEGES SIZE USER
ASSERT DBA GROUP NATUAL PROCEDURE SMALLINT VALIDATE
ASSIGN DEBUGOFF HAVING NATURALN PUBLIC SPACE VALUES
AT DEBUGON IDENTIFIED NEW RAISE SQL VARCHAR
AUDIT DECLARE IF NEXTVAL RANGE SQLCODE VARCHAR2
BETWEEN DECIMAL IMMEDIATE NOAUDIT RAW SQLERRM VARIANCE
BINARY_INTEGER DEFAULT IN NOCOMPRESS REAL START VIEW
BODY DEFINITION INCREMENT NOT RECORD STATE VIEWS
BOOLEAN DELAY INDEX NOWAIT REF STATEMENT WHEN
BY DELETE INDEXES NULL RELEASE STTDEV WHENEVER
CASE DESC INDICATOR NUMBER REMR SUBTYPE WHERE
CHAR DIGITS INITIAL NUMBER_BASE RENAME SUCCESSFUL WHILE
CHAR_BASE DISPOSE INSERT OF RESOURCE SUM WITH
CHECK DISTINCT INTEGER OFFLINE RETURN SYNONYM WORK
CLOSE DO INTERFACE ON REVERSE SYSDATE WRITE
CLUSTER DROP INTERSECT ONLINE REVOKE TABAUTH XOR
CLUSTERS ELSE INTO OPEN ROLLBACK TABLE  
COLAUTH ELSIF IS OPTION ROW TABLES  
COLUMN EXCLUSIVE LEVEL OR ROWID TASK  
COMMENT EXISTS LIKE ORDER ROWLABEL TERMINATE