Numeric with precision p and scale s. Precision can range from 1 to 38, scale from 0 to the precision.
NUMBERIC(p)                     Equivalent to numeric(p, 0).
NUMBERIC                        Equivalent to numeric(18, 0).
DECIMAL Although decimal is sometimes a distinct SQL data type, Netezza SQL treats it as an alias for numeric.

FLOAT(p)                        Floating point number with precision p, from 1 to 15. Precision less than 6 are equivalent to 6. Precision between 7 and 15 are equivalent to 15.
REAL                            Equivalent to float(6).
DOUBLE                          Equivalent to float(15).

CHAR(n)                         Fixed length, blank padded to length n. The default value of n is 1. The maximum character string size is 64,000.
VARCHAR(n)                      Variable length to a maximum length of n. No blank padding, stored as entered. The maximum character string size is 64,000.
NCHAR(n)                        Fixed length, blank padded to length n. The maximum length of 16,000 characters.
NVARCHAR(n)                     Variable length to a maximum length of n. The maximum length of 16,000 characters.

BOOLEAN (BOOL)                  With value true (t) or false (f).  You can use the following words to specify booleans: true or false, on or off, ‘0’ or ‘1’, “true’ or ‘false’, ‘t’ or ‘f’, ‘on’ or ‘off’, ‘yes’ or ‘no’.

DATE                            Ranging from January 1, 0001, to December 31, 9999.
TIME                            Hours, minutes, and seconds to 6 decimal positions. Ranging from 00:00:00.000000 to 23:59:59.999999.
TIME WITH TIME ZONE (TIMETZ)    Hours, minutes, seconds to 6 decimal positions, and time zone offset from GMT. Ranging from 00:00:00.000000+13:00 to 23:59:59.999999-12:59.
TIMESTAMP                       Has a date part and a time part, with seconds stored to 6 decimal positions. Ranging from January 1, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999.

INTERVAL (TIMESPAN)             EXPLAINED BELOW
               STANDARD SQL                                                                    NETEZZA SQL
Declares intervals as having particular units;                                  Accepts this syntax, but ignores the unit specification.
for example, colA interval year to month, or                                    All intervals are the same, and can contain
colB interval hour.                                                             values of any combination of units.

Does not include units in interval literals.                                    Requires that all literal values include the
For example, an interval year to month column's                                 units, as in “13 years 4 months,” because
values might be “13-4,” meaning 13                                              interval units pertain to a particular value
years and 4 months.                                                             rather than to a particular column's declaration.

Disallows declaring intervals as having both                                    Internally normalizes all intervals to units of
units smaller than a month and units                                            seconds. Considers a month to be thirty
greater than a day; for example, interval                                       days for the purposes of interval comparisons.
month to day, because this is ambiguous.                                        To avoid inaccuracies introduced by this approximation, use only

****************************** Netezza Internal Data Types ******************************
TYPE                COLUMN NAME                 VALUE
rowid               rowid                       100,000 - 9,223,372,036,854,775,807 8 bytes
transaction ID      createxid                   1024 - 9,223,372,036,854,775,807 8 bytes
                    deletexid                  
dataslice           datasliceid                 1 - 281,474,976,710,656 4 bytes
******************** THESE COLUMNS EXISTS ON ALL ROWS OF ALL TABLES *********************

// User Views
_v_view, _v_usergroups, _v_user, _v_table_index, _v_table_dist_map, _v_table, _v_session, _v_sequence, _v_relation_column_def, _v_relation_column,
_v_procedure, _v_operator, _v_index, _v_groupusers, _v_group, _v_function, _v_datatype, _v_database, _v_aggregate

// System Views
_v_sys_group_priv, _v_sys_index, _v_sys_priv, _v_sys_table, _v_sys_user_priv, _v_sys_view

// tree nodes under generic netezza jdbc driver.  They seem to have issues with there refresh.
Crypto Keystore
External Table
Index
Management Index
Management Seq
Management Table
Management View
Materialized View
Secure Base Table
Secure Base View
Secure Procedure
Secure System Seq
Secure System Table
Secure Table
Sequence
Synonym
System Index
System Seq
System Table
System View
Table
Temp Table
View
Virtual Table
Procedures
User Defined Types