Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Visual Studio Settings.
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