Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jgrant
Yak Posting Veteran
69 Posts |
 Posted - 2007-03-15 : 21:15:30
|
| is there a way to reorder columns in a table to change which one is displayed first?The Yak Village Idiot |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-15 : 21:22:13
|
Why do you want to do that ? The physical order of the column is insignificant. You can define what column to return in the SELECT statement.select col2, col100, col1from sometable
KH |
 |
|
|
jgrant
Yak Posting Veteran
69 Posts |
Posted - 2007-03-15 : 21:26:42
|
| oh yakcrap, you are correct. < This guy is a freakin idiot. Name well deserved.The Yak Village Idiot |
|
|
|
|
|
|
columns