View Single Post
  #2  
Old 04-02-2007, 10:47 AM
Saggie Saggie is offline
Senior Member
 
Join Date: Jul 2006
Posts: 155
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
Saggie is on a distinguished road
Default Re: moving columns??

Move your columns by altering your table. Also, to move a column you need to declare it again and then can tell where it belongs e.g. to change Col1, Col2 & Col3 to Col1, Col3 & Col2:

alter table
yourtablename
change col3 col3 varchar(15)
after col1 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - moving columns??
View Single Post
  #2  
Old 04-02-2007, 10:47 AM
Saggie Saggie is offline
Senior Member
 
Join Date: Jul 2006
Posts: 155
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
Saggie is on a distinguished road
Default Re: moving columns??

Move your columns by altering your table. Also, to move a column you need to declare it again and then can tell where it belongs e.g. to change Col1, Col2 & Col3 to Col1, Col3 & Col2:

alter table
yourtablename
change col3 col3 varchar(15)
after col1 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote