Bryan Pendleton wrote:
I saw the "alter table" only insert the column to the end of the table,
Yes, but you can retrieve your columns in any order. For example:
create table t (a int, b int, c int, d int);
alter table t add column e int;
What if they're using some kind of application which reads the database
metadata and automatically generates a form based on the columns present
in the table?
Daniel
--
Daniel Noll Forensic and eDiscovery Software
Senior Developer The world's most advanced
Nuix email data analysis
http://nuix.com/ and eDiscovery software
