How to change column order in a table using sql query in sql server 2005?

by

You cannot. The column order is just a “cosmetic” thing we humans care about – to SQL Server, it’s almost always absolutely irrelevant.

What SQL Server Management Studio does in the background when you change column order there is recreating the table from scratch with a new CREATE TABLE command, copying over the data from the old table, and then dropping it.

There is no SQL command to define the column ordering.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Select top 10 records for each category
  3. How important is the order of columns in indexes?
  4. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  5. sql query to return differences between two tables
  6. SQL Server – transactions roll back on error?
  7. Difference between a User and a Login in SQL Server
  8. Convert Xml to Table SQL Server
  9. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  10. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  11. Insert Picture into SQL Server 2005 Image Field using only SQL
  12. Convert varchar to uniqueidentifier in SQL Server
  13. Execute Stored Procedure from a Function
  14. How do I group on continuous ranges
  15. Paging SQL Server 2005 Results
  16. How to compare two dates to find time difference in SQL Server 2005, date manipulation
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. Restrict an SQL Server connection to a specific IP address
  19. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  20. SQL Server PIVOT perhaps?
  21. How to find consecutive rows based on the value of a column?
  22. Custom aggregate function (concat) in SQL Server
  23. SQL server identity column values start at 0 instead of 1
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. How to compare dates in SQL Server
  26. How do I expand comma separated values into separate rows using SQL Server 2005?
  27. Is there a quick way to check if ANY column is NULL?
  28. Why do SQL Server Scalar-valued functions get slower?
  29. SQL query for parent-child chain
  30. Querying Active Directory from SQL Server 2005

Leave a Comment