Re: full featured alter table?

>>>>> "Jim" == Jim C Nasby <jim(at)nasby(dot)net> writes:

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.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!