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 | ![]() |
CROSS | ![]() |
CURAID | ![]() |
CURRENT_DATE | ![]() ![]() |
CURRENT_TIME | ![]() ![]() |
CURRENT_TIMESTAMP | ![]() ![]() |
CURRENT_USER | ![]() |
CYCLE | ![]() |
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_TYPE | ![]() |
SQLDA | ![]() |
SQLERRM | ![]() |
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 | ![]() |
Table A-48 Reserved words that can be deleted (Y)
Reserved word | Disabled functionality |
---|---|
YEAR | ![]() ![]() ![]() |
YEARS | ![]() |