Database reserved Keywords

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