Re: COLUMN ORDER IN A TABLE

Why on earth do you want to do that? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: Hamid HABZI <HHABZI@bmcebank.co.ma> >To: ids@iiug.org >Subject: COLUMN ORDER IN A TABLE >Date: Sat, 11 Jan 2003 14:39:56 -0000 > >Hi, >Is there a way to change the order of column in a table? >e.g we have a table my table whith the following columns : >col1 >col2 >col3 >col4 > >and i want to have them in this order >col1 >col2 >col4 >col3 > >One way is to rename col3 to col3_old >create col3 >and then update the table like this : >update mytable >set col3 =col3_old >then delete col3_old. > >Tanks for your help. > > > >Hamid HABZI >DSI - Dpt Systèmes & Production >BMCE BANK >TEL 212 22 49 88 33 _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE* http://join.msn.com/?page=features/virus