Netezza Sql query

Question

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.

Answer 1

You can use this query.

SELECT * FROM _v_relation_keydata;