January 28, 2005 at 1:04 am
Is there anyway of changing the order of the columns in table by using T-SQL.
My Blog:
January 28, 2005 at 2:10 am
As far as I know,not without dropping and recreating the columns or the table.
The way enterprise manager changes column orders is to create a new table with the new order, copy the data over and drop the old table.
Why would you need to change column orders?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2005 at 2:13 am
thankx for the info.
this is a special purpose
My Blog:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply