Lew wrote:
> 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.
>
Especially the order of creation of tables (looks like that's what he's
asking)! Be glad you needn't worry aobut the trivial thing of insertion
or creation order. If you must know, add a timestamp field to your table
and fill it out accordingly.
--
Sabine Dinis Blochberger
Op3racional
www.op3racional.eu
|
