How to: Change Column Order (Visual Database Tools)

  • Article

You can change the order of columns in Table Designer.

Warning

Changing the column order of a table may affect code and applications that depend on the specific order of columns. These include queries, views, stored procedures, user-defined functions, and client applications. Carefully consider any changes you want to make to column order before making it.

To change the column order

  1. In Object Explorer, right-click the table with columns you want to reorder and click Design (Modify in SP1 or earlier).

    The table opens in Table Designer.

  2. Select the box to the left of the column name that you want to reorder.

  3. Drag the column to another location within the table.

See Also

Other Resources

Working with Columns (Visual Database Tools)
Modifying Columns (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance