CODEWITHSUNDEEP
sqlnetezza
Akshay J
Akshay J

Reputation: 5468

Netezza Sql query

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.

Upvotes: 5

Views: 17121

Answers (5)

DidICrumble
DidICrumble

Reputation: 31

SELECT database
        , schema
        , constraintname
        , relation as tablename
        , conseq as seq
        , attname as columnname, *
FROM _v_relation_keydata
where contype='p'
and schema='ADMIN'
order by relation, conseq

Upvotes: 2

Nivin Govindan
Nivin Govindan

Reputation: 11

The key(primary/foreign) concepts is not there in Netezza. But we can create primary keys in Netezza and this is created to sync the model with the outside data reporting tools like Informatica/Microstrategy.

You can look into the system view _v_relation_keydata.

Upvotes: 0

Mariappan Subramanian
Mariappan Subramanian

Reputation: 10083

We do not have primary key concept in Netezza. If you are concerned about Not NULL columns following query will help you.

select * from _v_relation_column where NAME='TABLE_NAME' and ATTNOTNULL='Y';

Upvotes: 0

Teja
Teja

Reputation: 13544

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]

Upvotes: 2

Winder
Winder

Reputation: 1984

You can use this query.

SELECT * FROM _v_relation_keydata;

Upvotes: 5

Related Questions