在 SuperMap中创建表（如属性表、数据集等）和字段的时候，对字段名称和数据集的名称有一定的限制：
- 由汉字、字母、数字和下划线组成，但不能以数字、下划线开头。
- 名称长度不得为0，也不得超过30个字节（即30个英文字母或者15个汉字）。
- 不能有非法字符，除数字、字母、汉字、下划线以外的所有字符，如空格、括号等。
- 不能与各个数据库的保留字段冲突。
Oracle 、SQL Server 等数据库均有一些保留的关键字，在 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 | 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 |
声明：若本文标注有“转载链接”或明文说明为“转载”，则为非本站作品，请保留原文链接；若未备注转载，则为老冯笔记作品，转载时请保留本文链接。
fengquanjia
老冯的微信
微信扫一扫，关注老冯，获得更多办公知识，更多晨草/书酷的动态！
评论