When creating tables (such as attribute tables, datasets, and so on) and fields in Supermap, there are certain restrictions on the name of the field name and dataset:
- Consists of Chinese characters, letters, numbers, and underscores, but cannot start with numbers or underscores.
- The name length must not be 0 or more than 30 bytes (that is, 30 English letters or 15 kanji).
- You cannot have illegal characters, except for numbers, letters, characters, and underscores, such as spaces, parentheses, and so on.
- Cannot conflict with reserved fields for individual databases.
Databases such as Oracle, SQL Server, and so on have some reserved keywords that cannot be used by table and field names when creating tables and fields in Supermap. Now put it out, hoping to bring some convenience to users. In addition to the reserved keywords listed below, Oracle automatically generates objects and sub-objects to the system beginning with "Sys_", so Oracle prevents the user from prefixing the specified object or sub-object with "Sys_", which could cause a naming resolution conflict.
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 |
Inch |
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 |
|
Database reserved Keywords