How do I list all the column names in Netezza?

sql netezza
Courtney picture Courtney · Jun 2, 2015 · Viewed 51.1k times · Source

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

Answer

Niederee picture Niederee · Jun 2, 2015

Within the same database you can use the following query:

select *
from _v_odbc_columns1
where column_name like '%columnname%'

or a less Netezza specific query

select *
from information_schema.columns
where column_name like '%columnname%'

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
Inserting multiple rows into a table using a single INSERT statement

I have no idea why I cannot insert values into my table using this syntax. I can insert one row but I cannot insert multiple rows. CREATE TABLE T1 ( ID BIGINT NULL, CAT VARCHAR(255) NULL, M_ID BIGINT NULL, T_…

Read More