Generate SQL allows you to reconstruct the SQL used to create existing database objects. This process is often referred to as reverse engineering. You can generate SQL for a Schema, Table, Type, View, Procedure, Function, Alias, and Index. Additionally, if you generate SQL for a table that has constraints or triggers associated with it, the SQL will be generated for those as well. You can generate the SQL for one object or many at a time. You also have the option of sending the generated SQL to Run SQL Scripts window for running or editing or you can write the generated SQL directly to a Database source file or a PC file.
For information about using Generate SQL, see the following: