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 |