| something about column [message #91] |
Fri, 11 January 2002 23:11  |
diana365
Messages: 4
Registered: January 2002
|
Junior Member |
|
|
|
can column be sorted?..i've created a table,but then i miss a column.i add it into the table..ok..but i want it to be the 2nd column..instead the last one.can we do that?
|
|
|
|
| Re: something about column [message #92 is a reply to message #91] |
Sat, 12 January 2002 10:11  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
no way, you have to drop table and recreate it.
if you have already data in it.
1)alter table tab1 rename to tab2;
2) create new table tab1 with proper order of columns
create table tab1 as select col1,col4,col2,col3 from tab2;
so that 4th column moves to second position
3) drop table tab2;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
