Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Change Column Order (Visual Database Tools)

Updated: 12 December 2006

You can change the order of columns in Table Designer.

Aa337556.Caution(en-US,SQL.90).gifCaution:
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.

  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.

Community Additions

ADD
Show:
© 2015 Microsoft