SQL common reserved words
The SQL language is composed of reserved words, that is, special words that run SQL operations.
Restriction: Do not use these reserved words
when you name databases, tables, columns, or any other database objects.
The
following table contains a list of the common reserved words.
| ABORT | DECIMAL | INTERVAL | PRESERVE |
| ALL | DECODE | INTO | PRIMARY |
| ALLOCATE | DEFAULT | LEADING | RESET |
| ANALYSE | DESC | LEFT | REUSE |
| ANALYZE | DISTINCT | LIKE | RIGHT |
| AND | DISTRIBUTE | LIMIT | ROWS |
| ANY | DO | LOAD | SELECT |
| AS | ELSE | LOCAL | SESSION_USER |
| ASC | END | LOCK | SETOF |
| BETWEEN | EXCEPT | MINUS | SHOW |
| BINARY | EXCLUDE | MOVE | SOME |
| BIT | EXISTS | NATURAL | TABLE |
| BOTH | EXPLAIN | NCHAR | THEN |
| CASE | EXPRESS | NEW | TIES |
| CAST | EXTEND | NOT | TIME |
| CHAR | EXTERNAL | NOTNULL | TIMESTAMP |
| CHARACTER | EXTRACT | NULL | TO |
| CHECK | FALSE | NULLS | TRAILING |
| CLUSTER | FIRST | NUMERIC | TRANSACTION |
| COALESCE | FLOAT | NVL | TRIGGER |
| COLLATE | FOLLOWING | NVL2 | TRIM |
| COLLATION | FOR | OFF | TRUE |
| COLUMN | FOREIGN | OFFSET | UNBOUNDED |
| CONSTRAINT | FROM | OLD | UNION |
| COPY | FULL | ON | UNIQUE |
| CROSS | FUNCTION | ONLINE | USER |
| CURRENT | GENSTATS | ONLY | USING |
| CURRENT_CATALOG | GLOBAL | OR | VACUUM |
| CURRENT_DATE | GROUP | ORDER | VARCHAR |
| CURRENT_DB | HAVING | OTHERS | VERBOSE |
| CURRENT_SCHEMA | IDENTIFIER_CASE | OUT | VERSION |
| CURRENT_SID | ILIKE | OUTER | VIEW |
| CURRENT_TIME | IN | OVER | WHEN |
| CURRENT_TIMESTAMP | INDEX | OVERLAPS | WHERE |
| CURRENT_USER | INITIALLY | PARTITION | WITH |
| CURRENT_USERID | INNER | POSITION | WRITE |
| CURRENT_USEROID | INOUT | PRECEDING | RESET |
| DEALLOCATE | INTERSECT | PRECISION | REUSE |
| DEC |
In addition, IBM® Netezza® SQL
considers the following system attributes reserved words:
- CTID
- OID
- XMIN
- CMIN
- XMAX
- CMAX
- TABLEOID
- ROWID
- DATASLICEID
- CREATEXID
- DELETEXID