Netezza Sql query

[akshaycjoshi]

Hi,
I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables.

Can anyone provide me the query.