Generate SQL Overview

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:

Generate SQL for database objects