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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2007-07-10 : 13:28:31
|
| There is a table in which has about 10,000,000 records.I want to move last column to second position but got error.How to fix it? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-10 : 13:33:05
|
| How does position of a column in a table matter? If your application is dependent on the position of the columns in the table, then you have a very bad design, I have to say. Are you doing "SELECT * FROm.."Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2007-07-10 : 13:36:17
|
| My app do not care of position |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-10 : 13:37:54
|
| Can you explain more details of why would you want to "move" the column from last position to 2nd?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-10 : 13:38:10
|
| then why do you want to move the column?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2007-07-10 : 13:40:15
|
| This table is for Access users to link and they want to change position of column |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-10 : 13:43:31
|
| Create a view for the Access users to link to.Or just tell them to deal with it the way it is.CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-10 : 13:43:45
|
tell them to go to hell.  but seriously can't they do this in access?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Move a column to a new location