Share via


General, Database Tools, Options Dialog Box

Use this page of the Options dialog box to change the default settings for database tools. You can access the Options dialog box from the Tools menu.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

Query, View, and Table Designers

  • Warn when changing schema
    Select this option to show a dialog asking if you are certain you want to change the schema (collection of database entities that form a single namespace) of the database object.

  • Issue the SET statements that ensure commits succeed
    Select this option to include special SET statements in any SQL script transmitted to a SQL Server database whenever you save a table or database diagram. The SET statements establish per-session settings that can affect the database objects created by the script. For example, if you check this option and connect to a SQL Server 2000 database, your updates to the database might include statements to control the QUOTED_IDENTIFIER, ANSI_PADDING, and ANSI_NULLS settings for the tables the script is creating.

Script and Stored Procedure, and Function Editors

Script/Query Execution

  • Warn when executing a script or query by dropping it on a reference
    Dragging a script file or query file to a database reference executes the script or query on the referenced database. Setting this option displays the Execute Scripts or Queries dialog box where you can proceed with the action by clicking Yes or cancel the action by clicking No.

See Also

Reference

Query/View Designer, Database Tools, Options Dialog Box

Table and Diagram Options, Table and Database Designers, Database Tools, Options Dialog Box

Column Options, Table and Database Designers, Database Tools, Options Dialog Box