Re: full featured alter table?

> Jim> The one thing we don't have that I think would be useful is a way to
> Jim> re-order the columns in a table. Maybe it's just me, but I tend to want
> Jim> column to appear in a specific order, and the only way you can
> Jim> accomplish this today is by re-creating the entire table.
>
> Column order shouldn't matter.  It matters only when you say "SELECT *",
> and the best literature out there warns against the foibles of such.

I think we don't want to reorder our column to make "select *" have a
order that fits our needs.

as i said in my other posts, we only want it for our selves to have a
defined order, that doesn't look that much chaotic.