Netezza Sql query

sql netezza
Akshay J picture Akshay J · Sep 16, 2010 · Viewed 14.7k times · Source

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

Winder picture Winder · Sep 24, 2010

You can use this query.

SELECT * FROM _v_relation_keydata;

Related questions

How to delete duplicate rows without unique identifier

I have duplicate rows in my table and I want to delete duplicates in the most efficient way since the table is big. After some research, I have come up with this query: WITH TempEmp AS ( SELECT name, ROW_NUMBER() …

Read More
Netezza SQL syntax to convert numeric YYYYMMDD format into date

We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731). What is the best Netezza syntax to use to convert this into date format? eg SELECT somefunction(20090731) as NZDATE ?

Read More
How do I list all the column names in Netezza?

Is there a query I can write to search all the column names for a particular database in Netezza?

Read More