Export (0) Print
Expand All
Expand Minimize

Generate SQL Scripts (Formatting Tab)

SQL Server 2000

  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.

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 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.

Script template

View the Transact-SQL script template that results from the options you have selected on this tab.

See Also

Documenting and Scripting Databases

Using Extended Properties on Database Objects

Show:
© 2015 Microsoft