Description of Reserved Field of Dataset |
When you create a dataset, an attribute table, and a field in SuperMap, there is a limit to the name and field name of the dataset:
The name can not be zero or more than 30 bytes (30 letters or 15 characters).
The name can only be composed of numbers, letters, Chinese characters, underline, and the name can not start with a number, underline.
The field name can not begin with "sm", but the data set name can begin with "sm", "sm" is the reserved keyword for the SDB and UDB engine's system default fields.
It cannot conflict with the reserved field of each database, refers to Table 1 Reserved keyword of UDB database and Table 2 Reserved keyword of Oracle database.
Table 1 Reserved keyword of UDB database
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 |
Table 2 Reserved keyword 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 |