sql - How do I list all the column names in Netezza?

Question

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

Answer 1

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%'