Re: Getting tables in insertion order

Sankar wrote:
>   I am working on a small utility to do database migration from one db
> to another.. Here i [sic] need to get list of tables in insertion
order.. I
> got list of tables by DatabaseMetaData.getTables()..  but it is giving
> tables in alphebetical order..

If this is a relational database system, then row order within the table
is 
inherently meaningless.

If this DMBS is like most, the records are very likely not stored in the
order 
in which they were inserted.  Many database systems s****t a row id, often 
named "OID" or something similar, that represents row order within a
table, 
but there is no hard guarantee that row id order matches insertion order,
even 
in systems where that's mostly true.

Unless tables are designed explicitly to record insertion time or
sequence, 
this is not a generally solvable problem.  Then again, row order is
supposed 
to be meaningless.

-- 
Lew