How to: Resize Property Columns in Tables (Visual Database Tools)

You can manually change the width of a property 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 alias data type names that are too long to see in their entirety.

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.