Generate SQL Scripts (Formatting Tab)
Topic last updated -- January 2004
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.
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 properties
Include extended properties 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.
View the Transact-SQL script template that results from the options you have selected on this tab.