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.