Netezza Sql query

Question

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;

Answer 2

There is nothing sort of Primary Key thing in Netezza. If you want to look at the NULL or NOT NULL constraints for your required table you can enter the below commands from your nzsql command line

\d [YOURTABLENAME]