Non-reserved keywords
Non-reserved keywords have a special meaning only in particular contexts and can be used as identifiers in other contexts. Most non-reserved keywords are actually the names of built-in tables and functions.
Netezza Performance Server SQL uses non-reserved
keywords to attach a predefined meaning to a word in a specific context. The following table
contains the list of non-reserved keywords.
| ABSOLUTE | ACTION | ADD | ADMIN |
| AFTER | AGGREGATE | ALIAS | |
| ALLOCATE | ALLOWED | ALTER | AND |
| ANY | ARE | ARRAY | AS |
| ASC | ASSERTION | AT | AUTHORIZATION |
| BEFORE | BEGIN | BINARY | BIT |
| BLOB | BOOLEAN | BOTH | BREADTH |
| BY | CALL | CASCADE | CASCADED |
| CASE | CAST | CATALOG | CHAR |
| CHARACTER | CHECK | CLASS | CLOB |
| CLOSE | COLLATE | COLLATION | COLUMN |
| COMMIT | COMPLETION | CONNECT | CONNECTION |
| CONSTRAINT | CONSTRAINTS | CONSTRUCTOR | CONTINUE |
| CORRESPONDING | CREATE | CROSS | CUBE |
| CURRENT | CURRENT_DATE | CURRENT_PATH | CURRENT_ROLE |
| CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
| CYCLE | DATA | DATE | DAY |
| DEALLOCATE | DEC | DECIMAL | DECLARE |
| DEFAULT | DEFERRABLE | DEFERRED | DELETE |
| DEPTH | DEREF | DESC | DESCRIBE |
| DESCRIPTOR | DESTROY | DESTRUCTOR | DETERMINISTIC |
| DIAGNOSTICS | DICTIONARY | DISCONNECT | DISTINCT |
| DOMAIN | DOUBLE | DROP | DYNAMIC |
| EACH | ELSE | END_EXEC | END |
| EQUALS | ESCAPE | EVERY | EXCEPT |
| EXCEPTION | EXEC | EXECUTE | EXTERNAL |
| FALSE | FENCED | FETCH | FINAL |
| FIRST | FLOAT | FOR | FOREIGN |
| FOUND | FREE | FROM | FULL |
| FUNCTION | GENERAL | GET | GLOBAL |
| GO | GOTO | GRANT | GROUP |
| GROUPING | HAVING | HOST | HOUR |
| IDENTITY | IGNORE | IMMEDIATE | IN |
| INDICATOR | INITIALIZE | INITIALLY | INNER |
| INOUT | INPUT | INSERT | INT |
| INTEGER | INTERSECT | INTERVAL | INTO |
| IS | ISOLATION | ITERATE | JOIN |
| KEY | LANGUAGE | LARGE | LAST |
| LATERAL | LEADING | LEFT | LESS |
| LEVEL | LIKE | LIMIT | LOCAL |
| LOCALTIME | LOCALTIMESTAMP | LOCATOR | MAP |
| MATCH | MINUTE | MODIFIES | MODIFY |
| MODULE | MONTH | NAMES | NATIONAL |
| NATURAL | NCHAR | NCLOB | NEW |
| NEXT | NO | NONE | NOT |
| NULL | NUMERIC | OBJECT | OF |
| OFF | OLD | ON | ONLY |
| OPEN | OPERATION | OPTION | OR |
| ORDER | ORDINALITY | OUT | OUTER |
| OUTPUT | PAD | PARALLEL | PARAMETER |
| PARAMETERS | PARTIAL | PATH | POSTFIX |
| PRECISION | PREFIX | PREORDER | PREPARE |
| PRESERVE | PRIMARY | PRIOR | PRIVILEGES |
| PROCEDURE | PUBLIC | READ | READS |
| REAL | RECURSIVE | REF | REFERENCES |
| REFERENCING | RELATIVE | RESTRICT | RESULT |
| RETURN | RETURNS | REVOKE | RIGHT |
| ROLE | ROLLBACK | ROLLUP | ROUTINE |
| ROW | ROWS | SAVEPOINT | SCHEMA |
| SCOPE | SCROLL | SEARCH | SECOND |
| SECTION | SELECT | SEQUENCE | SESSION |
| SESSION_USER | SET | SETS | SIZE |
| SMALLINT | SOME | SPACE | SPECIFIC |
| SPECIFICTYPE | SQL | SQLEXCEPTION | SQLSTATE |
| SQLWARNING | START | STATE | STATEMENT |
| STATIC | STRUCTURE | SYSTEM_USER | TABLE |
| TEMPORARY | TERMINATE | THAN | THEN |
| TIME | TIMESTAMP | TIMEZONE_HOUR | TIMEZONE_MINUTE |
| TO | TRAILING | TRANSACTION | TRANSLATION |
| TREAT | TRIGGER | TRUE | UNDER |
| UNION | UNIQUE | UNKNOWN | UNNEST |
| UPDATE | USAGE | USER | USING |
| VALUE | VALUES | VARCHAR | VARIABLE |
| VARYING | VIEW | WHEN | WHENEVER |
| WHERE | WITH | WITHOUT | WORK |
| WRITE | YEAR | ZONE |