| SQL adaptation guide for IBM Netezza 6.x / Data manipulation | |
Informix® allows the use of SQL language keywords for database object names (tables, columns):
CREATE TABLE table ( int INT, date DATE )
In Netezza®, SQL object names like table and column names cannot be SQL reserved keywords.
Table or column names which are Netezza reserved keywords must be renamed.
See the Netezza SQL Reference guide for a list of reserved keywords.