Generate SQL Scripts (Formatting Tab)
Use this tab to generate Transact-SQL statements that format the database objects you are creating. This is useful if you want to drop an existing object in one database, and then re-create it with the schema of a similar object from another database.
Options
Generate the CREATE <object> command for each object
Generate a Transact-SQL statement to create each object you selected on the General tab.
Generate the DROP <object> command for each object
Generate a Transact-SQL statement to drop each object you selected on the General tab.
Generate scripts for all dependent objects
Generate a Transact-SQL statement to add dependent objects for each object you selected on the General tab.
Include descriptive headers in the script files
Include explanatory header text prefacing each Transact-SQL statement in the script.
Include extended stored properties
Include extended stored procedures in the SQL scripts you create.
Only script 7.0 compatible features
Generate a script that is compatible with Microsoft® SQL Server™ version 7.0. If you select this option, the following SQL Server 2000 options will be ignored: column level collation, user-defined functions, extended property, INSTEAD OF trigger on tables and views, indexes on views (indexed views), indexes on computed columns, reference permissions on views, and descending indexes.
Script template
View the Transact-SQL script template that results from the options you have selected on this tab.