select * from _v_odbc_columns1 where column_name like '%columnname%'
或者更少的Netezza特定查询
select * from information_schema.columns where column_name like '%columnname%'
