Description of Reserved Field of Dataset |
When creating data sets, property tables, and fields in SuperMap, there are certain restrictions on the names of data sets and fields:
The length of the name shall not be 0 and shall not exceed 30 bytes (i.e. 30 English letters or 15 Chinese characters).
The name can only be composed of numbers, letters, Chinese characters and underscores, and the name cannot start with numbers or underscores.
A field name cannot start with "sm", but a dataset name can start with "sm", which is a reserved key for system default fields of the SDB and UDB engines.
It must not conflict with the reserved fields of each database, as detailed in Table 1 Reserved keywords of UDB database and Table 2 Reserved Keywords for Oracle Database .
Table 1 Reserved keywords 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 Keywords for 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 |