Reserved Keywords List for Databases

When creating tables (such as attribute tables or datasets) and fields in SuperMap, the following restrictions apply to field and dataset names:

  • Can consist of Chinese characters, letters, numbers, and underscores, but cannot start with a number, underscore, or 'sm'. 'sm' is a reserved keyword for system default fields in UDB engines.

    Note: Creating fields starting with 'sm' is prohibited, but datasets starting with 'sm' are allowed.

  • Fields cannot be named 'ssl'; the system will automatically append '_user' as a suffix.
  • Names must be between 1 and 30 bytes in length (equivalent to 30 English characters or 15 Chinese characters).
  • Must not contain illegal characters (any characters other than numbers, letters, Chinese characters, or underscores, such as spaces or parentheses).
  • Must not conflict with database-reserved fields. The reserved keywords for UDB/UDBX databases are listed below:
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