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.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
Use this page to determine the default behavior of the designer. To access the settings, on the Tools menu, select Options, expand the Designers folder, and select Table Designer.
Note
The SSMS table designer isn't available for tables in Azure Synapse Analytics Dedicated SQL pool (formerly SQL DW).
UI element list
Override connection string time-out value for table designer updates
Permits a new timeout value to be set for the actions of the table designer. This can be useful when the table designer affects a large table and requires extra time to complete the table modification.
Transaction time-out after
Sets a timeout value for the table designer.
Auto generate change scripts
Automatically creates a script to implement the changes defined in the table designer.
Warn on null primary keys
Provides a warning dialog box when a field that is selected for a primary key can contain null values.
Warn about difference detection
If you check this box, when you save the changes, a message box lists any conflicts between your changes and changes that were made by another user.
Warn about tables affected
Provides a warning dialog box that lists the tables that are affected by the action, and prompts for confirmation.
Prevent saving changes that require table re-creation
Prevents a user from making changes that require re-creating the table. The following actions might require a table to be re-created:
- Adding a new column to the middle of the table
- Dropping a column
- Changing column nullability
- Changing the order of the columns
- Changing the data type of a column
Default table view
Select the way you want to see tables in the designers:
Standard: Shows the table header, all column names, data types, and the Allow Nulls setting.
Column Names: Shows the column names.
Key: Shows the table header and the primary key columns.
Name Only: Shows only the table header with its name.
Custom: Allows you to choose which columns to view.
Launch add table dialog on new diagram
Automatically opens the Add Table dialog box when the designers open.