Toad World® Forums

ORGANIZE columns for Netezza tables

In Toad for Data Analysts 2.7, when I pick a table in the object browser and ask to ‘view Details’, it will show me the DISTRIBUTE key in the script tab and in fact shows a column DISTSEQNO in the Columns tab informing me of the distribution key.

That’s great. It’s super helpful.

However, there doesn’t seem to be any way of extracting the Organize key. If I create a table with
CREATE TABLE SCHMABLE(SchmableID) DISTRIBUTE ON (SCHMABLEID) ORGANIZE ON (SCHMABLEID);
it’ll report as
CREATE TABLE SCHMABLE(SchmableID) DISTRIBUTE ON (SCHMABLEID)

Can I see the Organizing key in TOAD somehow?