Generating SQL for existing objects

 

You can reconstruct the SQL that was used to create existing database objects in the Generate SQL window of iSeries™ Navigator. You can generate SQL for most database objects. Additionally, if you generate SQL for a table that has constraints or triggers associated with it, the SQL is generated for those constraints or triggers as well. You can generate SQL for one object or many objects at a time. You can also send the generated SQL to the Run SQL Scripts window for running or editing, or you can write the generated SQL directly to a database or PC file.

To generate SQL for an object, right-click the object and select Generate SQL.

You can also open the Generate SQL window by selecting Insert Generated SQL from the Edit menu in the Run SQL Scripts window.

 

Parent topic:

Querying your database by running SQL scripts