CODEWITHSUNDEEP
netezza
Harry
Harry

Reputation: 41

In netezza aginity how to get the structure of the table

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.

Upvotes: 4

Views: 13041

Answers (2)

Andrew
Andrew

Reputation: 1618

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

Upvotes: 0

Leo
Leo

Reputation: 898

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.

Upvotes: 5

Related Questions