Aginity For Netezza – How to Generate DDL

Aginity, Aginity for Netezza, Netezza, PureData, DDL, SQL

Aginity

How to Generate Netezza Object DDL

In ‘Aginity for Netezza’ this process is easy, if you have a user with sufficient permissions.

The basic process is:

  • In the object browser, navigate to the Database
  • select the Object (e.g. table, view, stored procedure)
  • Right Click, Select ‘Script’ > ‘DDL to query window’
  • The Object DDL will appear in the query window
Create DDL to Query Window

Create DDL to Query Window

Related References

 

Advertisements

2 thoughts on “Aginity For Netezza – How to Generate DDL

  1. Pingback: Netezza / PureData – Table Describe SQL | Scientia Compendium

  2. Pingback: Netezza / PureData – How to rebuild a Netezza view in Aginity | Scientia Compendium

Comments are closed.