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

  • Article

Use this page of the Options dialog box to change the defaults for tables in the Table Designer. 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 Customizing Development Settings in Visual Studio.

Table Options

  • Override connection string time-out value for table designer updates
    The connection string timeout value, which is set in the Add Connections (or Modify Connections) dialog box, can be overridden for table updates in Table designer.

  • Transaction time-out after
    Provides a text box where you can type in the number of seconds to allow before a timeout error occurs.

  • Auto generate change scripts
    If you check this box, you are prompted to generate a change script each time you save modified tables.

  • Warn on null primary keys
    If you check this box, a message appears if you try to change a primary key to allow nulls.

  • Warn about difference detection
    If you check this box, when you save the changes a message box will list any conflicts between your changes and changes made by another user.

  • Warn about tables affected
    If you check this box and make a change that will affect tables other than the one you are working on, when you save the changes you will receive a notice telling you which tables will be affected.

Diagram Options

  • Default table view
    Controls the column layout when you add a table to a diagram.

    • Standard

      The table will be shown with the following properties for each column: Column Name, Data Type, Allow Nulls.

    • Column names

      The table will be shown with only the column names.

    • Keys

      The table will be shown with only the column names for the key columns.

    • Names Only

      Only the table name will be shown.

    • Custom

      The table will be shown with properties you select for each column. See the See Also section for more information.

  • Launch add table dialog on new diagram
    If you check this box, when you add a new diagram the Add Table dialog will appear.

See Also

Tasks

How to: Generate Change Scripts

How to: Customize the Amount of Information Displayed in Diagrams

Reference

Database Diagram Properties

Table Properties

Add Table Dialog Box (Query and View Designers)