In netezza aginity how to get the structure of the table

netezza
Harry picture Harry · Dec 28, 2017 · Viewed 7.7k times · Source

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.

Answer

Leo picture Leo · Mar 28, 2018

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.

Related questions

How do I convert date in Netezza to yyyymmdd from timestamp format?

How do I convert date in Netezza to yyyymmdd from timestamp format?

Read More
How to delete duplicate rows without unique identifier

I have duplicate rows in my table and I want to delete duplicates in the most efficient way since the table is big. After some research, I have come up with this query: WITH TempEmp AS ( SELECT name, ROW_NUMBER() …

Read More
create synonym for table in a database hosted in a different server

In oracle, if the other database is within the same server, I did the following to create a synonym CREATE SYNONYM synonymName FOR databaseName.schema.table; What should I do to create a synonym for tables in a database hosted …

Read More