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 |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2008-04-10 : 02:51:57
|
| HiWhen I run this query..SELECT COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME='TableTest'I get all the column names, but the result is not in the same order as when I check the design for the table, why is that? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-10 : 03:08:59
|
SELECT COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME='TableTest'order by ORDINAL_POSITION
elsasoft.org |
 |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-04-10 : 05:06:25
|
| :-)Thanks! |
|
|
|
|
|
|
column names