How to: Resize Columns in Tables
You can manually change the width of a table column in Table Designer by resizing it or you can automatically resize a column to fit its widest entry. For example, you can widen the Data Type column if it contains user-defined data type names that are too long to see in their entirety.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To manually change the width of a column
Position the pointer along the right border of the column header for the column that you want to resize. The cursor changes from an arrow to a splitter pointer.
Note
This works on the tables in the Visual Database Tools, such as the Properties window, as well as your database tables and queries.
Drag the column border to the left to reduce its width or to the right to increase its width.
Release the mouse button.
To resize a column to fit the widest entry
Position the pointer along the right border of the column header for the column that you want to resize. The cursor changes from an arrow to a splitter pointer.
Note
This works on the tables in the Visual Database Tools, such as the Properties window, as well as your database tables and queries.
Double-click the splitter pointer.