List of reserved keywords for the database

When creating tables and fields in SuperMap, there are certain restrictions on the names of Field and Dataset:

  1. The length of the name shall not be 0 and shall not exceed 30 bytes (i.e. 30 English letters or 15 Chinese characters);
  2. Cannot start with a number, underscore, or "sm";
  3. No illegal characters are allowed. Illegal characters are all characters except numbers, letters, Chinese characters and underscores;
  4. Cannot conflict with the reserved key for each database. The following table lists the keys for each database.

Oracle and other databases have some reserved keywords. When creating tables and fields in SuperMap, these keywords cannot be used in table names and field names. Now we sort them out in the hope of bringing 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.

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