Generate SQL Scripts (General Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Generate SQL Scripts (General Tab)

Use this tab to generate Transact-SQL statements that create objects identical to those currently in your database. This is useful if you want to create objects on other servers with the same schema as those in your original database.

Options

Show All

View all available objects for scripting.

Preview

Preview the Transact-SQL script that will be created from the options you select.

Script all objects

Include all database objects in the Transact-SQL script.

All tables
Include all database tables in the Transact-SQL script.
All views
Include all database views in the Transact-SQL script.
All stored procedures
Include all database stored procedures in the Transact-SQL script.
All defaults
Include all database defaults in the Transact-SQL script.
All rules
Include all database rules in the Transact-SQL script.
All user-defined data types
Include all database user-defined data types in the Transact-SQL script.
All user-defined functions
Include all database user-defined functions in the Transact-SQL script.

Objects on

View the list of objects in the database that are not included in the Transact-SQL script.

Objects to be scripted

View the list of objects in the database that are included in the Transact-SQL script.

Add

Add database objects to the Transact-SQL script.

Remove

Remove database objects from the Transact-SQL script.

See Also

Documenting and Scripting Databases