SuperMap 数据集保留字段

在 SuperMap 中创建数据集、属性表和字段的时候，对数据集的名称和字段名称有一定的限制：

名称长度不得为0，也不得超过30个字节（即30个英文字母或者15个汉字）。
名称只能由数字、字母、汉字、下划线组成，且名称不能以数字、下划线开头。
字段名不能以“sm”开头，但是数据集名可以为“sm”开头，“sm”为 SDB 和 UDB 引擎的系统默认字段的保留关键字。
不能与各个数据库的保留字段冲突，详见表1_UDB_数据库保留关键字和表2_Oracle_数据库保留关键字。

表1 UDB 数据库保留关键字

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

表2 Oracle 数据库保留关键字

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