Reserved Keywords in Database
There are some restrictions in datasets or fields creation, especially about their names:
- The length of name string can not be zero or over 30 bytes (that is 30 letters or 15 Chinese characters are allowed ), typically to SDM for Oracle data, the actual length is 18 bytes because some extra characters may be appended to the original name after some operations such as index creation being performed.
- Figure, underline or initial with “sm” are not allowed.
- All characters except for figure, letter, Chinese character, underline are not allowed;
- Can not conflict with the reserved keywords of databases which has been listed as below:
In Oracle or Microsoft Access database, there are some reserved keywords can not be used when creating dataset or field. In addition to the following listed keywords, the system generated objects in Oracle will be named with SYS_ as prefix; therefore, any prefixes with SYS_ will be rejected in Oracle.
| 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 | AND | FORM | 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 | IN | 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 | INDINDICATOR | 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 | . |
Bookmark this site.