db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: How to insert new column in front of exsiting column?
Date Wed, 13 May 2009 23:33:45 GMT
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

Mime
View raw message