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


is there query can write search column names particular database in netezza?

within same database can use following query:

select * _v_odbc_columns1 column_name '%columnname%' 

or less netezza specific query

select * information_schema.columns column_name '%columnname%' 

Comments