Generate Script (Options Tab)

Use this tab to generate Transact-SQL statements that further refine the creation of objects on a database. You can specify security, table creation, and file saving options.

Generate the CREATE statement for each object
Generate a Transact-SQL statement to create each object you selected.

Generate the DROP statement for each object
Generate a Transact-SQL statement to drop each object you selected.

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/2005 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 database
Generate a Transact-SQL statement to create a script of the existing database schema.

Script database users and roles
Generate a Transact-SQL statement to create all users and roles that have access to the database.

Script SQL Server logins
Generate a Transact-SQL statement to create all logins that currently have access to the server.

Script object-level permissions
Generate a Transact-SQL statement to create all grant, revoke, and deny permissions that currently exist for each object selected on the General tab.

Script indexes
Generate a Transact-SQL statement to create indexes that currently exist for any selected tables. This option is useful only if one or more tables are to be scripted.

Script full-text indexes
Generate a Transact-SQL statement to create full-text indexes. This option is useful only if one or more tables are to be scripted.

Script triggers
Generate a Transact-SQL statement to create triggers that exist for any selected tables. This option is useful only if one or more tables are to be scripted.

Script PRIMARY keys, FOREIGN keys, defaults, and check constraints
Generate a Transact-SQL statement to create PRIMARY keys, FOREIGN keys, defaults, and check constraints that exist for any selected tables. This option is useful only if one or more tables are to be scripted.

Output file format

MS-DOS text (OEM)	Save the Transact-SQL script in the format of the current Microsoft Windows system code page. Select this option if you will use the script in a batch operation and execute it from the command prompt using a console application such as Isql.exe.
Windows text (ANSI)	Save the Transact-SQL script in ANSI format. Select this option if the script will be used in a Windows application.
International text (Unicode)	Save the Transact-SQL script in Unicode format. Select this option if the script uses special international characters that are supported only in the Unicode font. This format requires two times the disk space of either the current Windows code page or ANSI.

Create one file
Save one file that includes all Transact-SQL statements for every object you have selected.

Create one file per object
Save one file for each distinct object you have selected.