在 SuperMap 中创建表和字段的时候，对字段名称和数据集的名称有一定的限制：
- 名称长度不得为0，也不得超过30个字节（即30个英文字母或者15个汉字）；
- 不能以数字、下划线及“sm”开头；
- 不能有非法字符，非法字符即除数字、字母、汉字、下划线以外的所有字符；
- 不能与各个数据库的保留关键字冲突，下表列出了各个数据库的关键字。
Oracle 等数据库均有一些保留的关键字，在 SuperMap 中创建表和字段的时候，表名和字段名都不能使用这些关键字，现在把它整理出来，希望给用户带来一些方便。除了下面列出的保留关键字外，Oracle对系统自动生成的对象及子对象以”SYS“开头，因此Oracle会阻止用户为指定的对象或子对象以”SYS“为前缀，否则有可能引起命名解析冲突。
表：表名和字段名都不能使用关键字列表
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 | PLSINTEGER | SCHEMA | UID
ANY | CURRVAL | FROM | MINUS | POSITIVE | SELECT | UNION
ARRAY | CURSOR | FUNCTION | MLSLABEL | POSITIVEN | SEPARATE | UNIQUE
ARRAYLEN | DATABASE | GENERIC | MOD | PRAGMA | SESSION | UPDATE
AS | DATABASE | 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
BINARYINTEGER | 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 | NUMBERBASE | 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 |