4

In Oracle, we can give like desc table_name, but as I am using the Netezza, so I couldn't get the description of the tables. If anyone knows please let me know.

Harry
  • 41
  • 1
  • 1
  • 2
  • 1
    Possible duplicate of [How do I list all the column names in Netezza?](https://stackoverflow.com/questions/30607280/how-do-i-list-all-the-column-names-in-netezza) – shinjw Dec 28 '17 at 08:12

2 Answers2

5

Right click on Table in Object Browser --> Script --> DDL to query Window

There is another nzsql command : \d <TABLE_NAME> The nzsql commands apply only if you use command line (eg:putty). Not on Aginity.

Leo
  • 868
  • 1
  • 13
  • 32
0

Here is a metadata query to give the structure of tables and views. There is one row per column, and it describes the data types.

SELECT *
FROM _v_relation_column
Andrew
  • 1,619
  • 3
  • 19
  • 24