Tables A-27 to A-48 show the reserved words that can be deleted by using the SQL reserved word deletion facility, and the functionality that is disabled if a given reserved word is deleted.
The following legend is used in the tables:
Table A-27 Reserved words that can be deleted (A)
Reserved word | Disabled functionality |
---|---|
ABS | ![]() |
ALLOCATE | ![]() ![]() |
AMOUNT | -- |
ANDNOT | ![]() |
ANSI | -- |
ARRAY | ![]() |
ASSERTION | -- |
ASYNC | -- |
AUTO | -- |
Table A-28 Reserved words that can be deleted (B)
Reserved word | Disabled functionality |
---|---|
BASE | -- |
BEGIN | ![]() ![]() |
BINARY | ![]() |
BIT_AND_TEST | ![]() |
BLOB | ![]() |
BOOLEAN | ![]() |
BOTH | -- |
BREADTH | -- |
BTREE | -- |
BUFFER | -- |
BYTE | -- |
Table A-29 Reserved words that can be deleted (C)
Reserved word | Disabled functionality |
---|---|
CALL | ![]() ![]() |
CASE | ![]() |
CAST | ![]() |
COALESCE | ![]() |
COLUMNS | -- |
COMPLETION | -- |
CONDITION | ![]() |
CONFIGURATION | -- |
CONST | -- |
CONSTRAINT | ![]() |
CONTIGUOUS | -- |
CORRESPONDING | -- |
COUNT_FLOAT | ![]() |
CROSS | -- |
CURAID | -- |
CURRENT_DATE | ![]() ![]() |
CURRENT_TIME | ![]() ![]() |
CURRENT_TIMESTAMP | ![]() ![]() |
CURRENT_USER | -- |
CYCLE | Sequence generator cycle option for the CREATE SEQUENCE statement |
Table A-30 Reserved words that can be deleted (D)
Reserved word | Disabled functionality |
---|---|
DATA | ![]() |
DATABASE | -- |
DATE | ![]() ![]() ![]() ![]() |
DAY | ![]() ![]() ![]() |
DAYS | ![]() ![]() |
DEFER | -- |
DEMOTING | -- |
DEPTH | -- |
DEVICE | -- |
DIAGNOSTICS | ![]() |
DICTIONARY | -- |
DIGITS | ![]() |
DIRECT | -- |
DO | ![]() |
DOUBLE_PRECISION | -- |
Table A-31 Reserved words that can be deleted (E)
Reserved word | Disabled functionality |
---|---|
EACH | ![]() |
EDIT | -- |
ELSE | ![]() |
ELSEIF | ![]() |
ENCRYPT | -- |
END | ![]() ![]() |
EQUALS | -- |
ESTIMATED | -- |
EXCEPTION | ![]() |
EXIT | ![]() |
EXTERN | -- |
EXTRACT | -- |
Table A-32 Reserved words that can be deleted (F)
Reserved word | Disabled functionality |
---|---|
FALSE | ![]() |
FIXED | -- |
FORCE | -- |
FREE | ![]() |
FULL | -- |
FUNCTION | ![]() ![]() ![]() |
Table A-33 Reserved words that can be deleted (G)
Reserved word | Disabled functionality |
---|---|
GENERAL | -- |
GET | ![]() |
GET_JAVA_STORED_ROUTINE_SOURCE | ![]() |
Table A-34 Reserved words that can be deleted (H)
Reserved word | Disabled functionality |
---|---|
HANDLER | ![]() |
HELP | -- |
HEX | ![]() |
HOUR | ![]() ![]() ![]() |
HOURS | ![]() |
HUGE | -- |
Table A-35 Reserved words that can be deleted (I)
Reserved word | Disabled functionality |
---|---|
IF | ![]() |
IGNORE | -- |
INNER | ![]() |
INOUT | ![]() |
INTERSECT | -- |
INTERVAL | ![]() ![]() |
ISOLATION | ![]() |
IS_USER_CONTAINED_IN_HDS_GROUP | ![]() |
Table A-36 Reserved words that can be deleted (L)
Reserved word | Disabled functionality |
---|---|
LARGE | ![]() |
LEADING | -- |
LEAVE | ![]() |
LENGTH | ![]() ![]() |
LESS | -- |
LEVEL | ![]() |
LIMIT | ![]() |
LINES | -- |
LINK | -- |
LOCATOR | -- |
LOCKS | -- |
LOGID | -- |
LOGNAME | -- |
LOOP | -- |
LOWER | ![]() |
Table A-37 Reserved words that can be deleted (M)
Reserved word | Disabled functionality |
---|---|
MAXUSAGES | -- |
MINUTE | ![]() ![]() |
MINUTES | ![]() |
MOD | ![]() |
MONTH | ![]() ![]() |
MONTHS | ![]() |
MOVE | -- |
Table A-38 Reserved words that can be deleted (N)
Reserved word | Disabled functionality |
---|---|
NATURAL | -- |
NEW | ![]() |
NOWAIT | ![]() |
NULLIF | ![]() |
Table A-39 Reserved words that can be deleted (O)
Reserved word | Disabled functionality |
---|---|
OFF | -- |
OID | -- |
OLD | ![]() |
ONLY | ![]() ![]() ![]() |
OPERATION | -- |
OPERATORS | -- |
OPTIMIZE | ![]() |
OTHERS | -- |
OUT | ![]() |
OUTER | ![]() |
OVER | ![]() |
OVERFLOW | -- |
OWN | -- |
Table A-40 Reserved words that can be deleted (P)
Reserved word | Disabled functionality |
---|---|
PARAMETERS | -- |
PENDANT | -- |
PIC | -- |
PICTURE | -- |
PREALLOCATED | -- |
PREFERRED | -- |
PREORDER | -- |
PRIVATE | ![]() |
PROTECTED | ![]() |
PURGE | ![]() ![]() ![]() |
Table A-41 Reserved words that can be deleted (R)
Reserved word | Disabled functionality |
---|---|
RANDOM | -- |
RD | -- |
READ | ![]() ![]() |
RECOMPILE | -- |
RECOVERABLE | -- |
RECURSIVE | -- |
REF | -- |
REFERENCING | ![]() |
REGLIKE | -- |
RELEASING | -- |
RESTART | -- |
RETURN | ![]() |
RETURNS | ![]() |
RIGHT | -- |
ROLE | -- |
ROOT | -- |
ROUTINE | ![]() |
ROW | ![]() ![]() ![]() |
ROWS | -- |
Table A-42 Reserved words that can be deleted (S)
Reserved word | Disabled functionality |
---|---|
SAVEPOINT | -- |
SCALE | -- |
SCAN | -- |
SCHEMAS | -- |
SCOPE | -- |
SD | -- |
SEARCH | -- |
SECOND | ![]() ![]() ![]() |
SECONDS | ![]() |
SENSITIVE | -- |
SEPARATE | -- |
SEPARATOR | -- |
SEQUENCE | ![]() ![]() |
SESSION_USER | -- |
SFLIKE | -- |
SHORT | -- |
SIGNAL | ![]() |
SIMILAR | ![]() |
SLOCK | -- |
SQL_STANDARD | -- |
SQLCODE_OF_LAST_CONDITION | ![]() |
SQLCODE_TYPE | -- |
SQLDA | -- |
SQLERRM | -- |
SQLERRM_OF_LAST_CONDITION | ![]() |
SQLERRMC | -- |
SQLERRML | -- |
SQLEXCEPTION | -- |
SQLWARN | -- |
STATIC | -- |
STOP | -- |
STOPPING | -- |
SUBSTR | ![]() ![]() |
SYSTEM_USER | -- |
Table A-43 Reserved words that can be deleted (T)
Reserved word | Disabled functionality |
---|---|
TEST | -- |
TEXT | -- |
THEN | ![]() ![]() |
THERE | -- |
TIME | ![]() ![]() ![]() ![]() |
TIMESTAMP | ![]() ![]() ![]() ![]() |
TIMESTAMP_FORMAT | ![]() |
TRAILING | -- |
TRANSACTION | -- |
TREAT | -- |
TRIGGER | ![]() ![]() |
TRIM | -- |
TRUE | ![]() |
TYPE | ![]() ![]() ![]() |
Table A-44 Reserved words that can be deleted (U)
Reserved word | Disabled functionality |
---|---|
UAMT | -- |
UBINBUF | -- |
UCHAR | -- |
UDATE | -- |
UHANT | -- |
UHDATE | -- |
UNDER | ![]() |
UNIFY_2000 | -- |
UNIONALL | -- |
UNKNOWN | ![]() |
UNLIMITED | -- |
UNLOCK | -- |
UNTIL | ![]() |
UPPER | ![]() |
USAGE | ![]() |
USE | -- |
UTIME | -- |
UTXTBUF | -- |
Table A-45 Reserved words that can be deleted (V)
Reserved word | Disabled functionality |
---|---|
VALUE | ![]() ![]() |
VARCHAR_FORMAT | ![]() |
VARIABLE | -- |
VARYING | ![]() |
VIRTUAL | -- |
VISIBLE | -- |
VOLATILE | -- |
VOLUME | -- |
VOLUMES | -- |
Table A-46 Reserved words that can be deleted (W)
Reserved word | Disabled functionality |
---|---|
WHEN | ![]() ![]() |
WHILE | ![]() ![]() |
Table A-47 Reserved words that can be deleted (X)
Reserved word | Disabled functionality |
---|---|
XLOCK | -- |
XML | ![]() ![]() |
XMLAGG | ![]() |
XMLEXISTS | ![]() |
XMLPARSE | ![]() |
XMLQUERY | ![]() |
XMLSERIALIZE | ![]() |
Table A-48 Reserved words that can be deleted (Y)
Reserved word | Disabled functionality |
---|---|
YEAR | ![]() ![]() ![]() |
YEARS | ![]() |