Database version: Netezza 7.0

Aqua Data Studio 14.0.3
Build #: 34446
Built on: 2013-Oct-16 12:54:43 PM

Windows 7: 64 bit

Step 1: Connect to Netezza 7.0

Step 2:  Create database.

             CREATE DATABASE "test_db"

Step3: In “test_db”, Create table.

        CREATE TABLE "table_demo"  (

        "c1"    VARCHAR(25) NOT NULL,

        "c2"    VARCHAR(25) NULL,

        "c3"    VARCHAR(25) NULL,

        CONSTRAINT "pk1" PRIMARY KEY("c1") DEFERRABLE INITIALLY IMMEDIATE  )

        GO

Step 4: Right click on table -> Open Query Analyzer window.

            Write  query (select * from <TABLE_NAME> where -> hit space.

Here, column list of table should populate but not observed in this case.

Same behavior is found for insert, update, delete commands. List of tables for auto completion is populated but list of columns for tables is not populated.