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

Change Column Order in a Table

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

You can change the order of columns in Table Designer in SQL Server 2016 by using SQL Server Management Studio.

Caution note Caution

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. Best practice is to specify the order in which the columns are returned at the application and query level. You should not rely on the use of SELECT * to return all columns in an expected order based on the order in which they are defined in the table. Always specify the columns by name in your queries and applications in the order in which you would like them to appear.

In This Topic

To change the column order

  1. In Object Explorer, right-click the table with columns you want to reorder and click Design.

  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.

Arrow icon used with Back to Top link [Top]

To change the column order

This task cannot be performed using Transact-SQL statements.

Community Additions

© 2015 Microsoft