IDS Forum

Re: COLUMN ORDER IN A TABLE

Posted By: Obnoxio The Clown
Date: Friday, 17 January 2003, at 5:37 a.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.