Insert generated SQL

Inserting generated SQL allows you to reconstruct the SQL statements used to create existing database objects, a process sometimes refered to as reverse engineering. You can generate SQL for a schema, table, type, view, procedure, function, alias, or index. Additionally, if the object that you choose to reverse engineer has other objects or attributes associated with it, the SQL statements for those objects or attributes are included as well. For example, if you generate SQL for a table that has constraints or triggers associated with it the SQL is generated for those as well. You can generate SQL for one object or many at a time.

To insert generated SQL:

  1. Open Run SQL Scripts.
  2. From the Edit menu, select Insert Generated SQL.
  3. On the Generate SQL dialog, select the object for which you want to generate SQL from the Objects for which to Generate SQL list. If the object does not exist in the Objects for which to generate SQL list, click Add to find the object for which you want to generate SQL.
  4. If necessary, select the Options and Format that you want for the generated SQL.
  5. Click OK.