If you want to describe a PureData / Netezza table in SQL, it can be done, but Netezza doesn’t have a describe command. Here is a quick SQL, which will give the basic structure of a table or a view. Honestly, if you have Aginity Generating the DDL is fast and more informative, at least to me. If you have permissions to access NZSQL you can also use the slash commands (e.g. d).
Example Netezza Table Describe SQL
select name as Table_name,
owner as Table_Owner,
Createdate as Table_Created_Date,
type as Table_Type,
Database as Database_Name,
schema as Database_Schema,
attnum as Field_Order,
attname as Field_Name,
format_type as Field_Type,
attnotnull as Field_Not_Null_Indicator,
attlen as Field_Length
from _v_relation_column
where
name='<<Table Name Here>>’
Order by attnum;
Related References
- Aginity For Netezza – How to Generate DDL
- Netezza / PureData – How to rebuild a Netezza view in Aginity
- [HY000] ERROR: Base table/view has changed (datatype); rebuild view
- Aginity Workbench for PureData /Netezza System for Analytics – Useful links
- Netezza / PureData – What client tools to use with Netezza
- Aginity for Netezza – How to disable and/or Enable the Autocomplete Function
- Aginity Workbench for PureData /Netezza System for Analytics – Useful links