List of reserved keywords for the database

When creating tables (such as property tables, Dataset, etc.) And fields in SuperMap, there are certain restrictions on the names of Field and Dataset:

  • It is composed of Chinese characters, letters, numbers and underscores, but it cannot start with numbers, underscores and "sm". "Sm" is a reserved key for the system default field of the UDB engine.

    Note that you cannot create a new field that starts with "sm", but you can create a Dataset that starts with "sm".

  • Fields cannot be named with "SSL" and are automatically suffixed with "_ user".
  • The length of the name shall not be 0 and shall not exceed 30 bytes (i.e. 30 English letters or 15 Chinese characters).
  • There can be no illegal characters, all characters except numbers, letters, Chinese characters and underscores, such as spaces, brackets, etc.
  • Cannot conflict with Reserved Fields for individual databases.

UDB, Oracle, SQL Server and other databases have some reserved keywords. When creating tables and fields in SuperMap, these keywords cannot be used for table names and field names. Now the UDB/UDBX and Oracle database keywords are sorted out, hoping to bring some convenience to users. In addition to the reserved keywords listed below, Oracle prefixes automatically generated objects and subobjects with "SYS _", so Oracle prevents users from prefixing a given object or subobject with "SYS _", which could cause naming resolution conflicts.

UDB/UDBX database reserved keywords

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  

Oracle Database Reserved Keywords

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