Database Projects Options (Data Tools—Options Dialog Box)

Allows you to set database projects options, such as what types of scripts are included in the database project.

These options apply when you choose the Copy Script command from the shortcut menu for one of the database objects displayed in Data View. These options determine the types of script commands that can be included in the copied scripts. When these scripts are added to a database project, these options determine what types of database objects and database settings the script can create. For more information on SQL scripts and the syntax used in them, see your SQL database documentation.

The database projects options can be set from the Options dialog box on the Tools menu in the Database Projects tab of Data Tools.

Options

Script details

Include drop script

Select to include drop commands in your script. This option is selected by default.

Include permission script

Select to include permission (GRANT) commands in your script. This option is selected by default.

Table script details

Include table indexes

Select to include commands that define table indexes in your script. This option is selected by default.

Include triggers

Select to include commands that define table triggers in your script. This option is selected by default.

Include keys/DRI

Select to include commands that define table keys and declarative referential integrity in your script. This option is selected by default.