Share via


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

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.

To manually change the width of a column

  1. 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.

  2. Drag the column border to the left to reduce its width or to the right to increase its width.

  3. Release the mouse button.

To resize a column to fit the widest entry

  1. 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.

  2. Double-click the splitter pointer.

See Also

Other Resources

Working with Tables in Table Designer