where is database metadata?

  • Thread starter Thread starter oldtimer
  • Start date Start date
O

oldtimer

I have to copy Access97 databases to Oracle.
To do so I need access to the Access97 metadata.
I have found the table names in MSysObjects but cannot find the column
descriptors.
Can you help?
 
I have to copy Access97 databases to Oracle.
To do so I need access to the Access97 metadata.
I have found the table names in MSysObjects but cannot find the column
descriptors.
Can you help?
Click to expand...

MSysObjects is not documented, and has changed in structure from version to
version.

There are no simple equivalents to SQL or Oracle's metadata tables,
unfortunately!
 
MSysObjects is not documented, and has changed in structure from
version to version.
Click to expand...

Michael Kaplan claimed that once something was implemented in the
system tables, it was never changed. So, things may have been added,
but nothing that has ever existed is supposed to have been changed.
Do you have an example that would contradict what MichKa used to say
about that subject?
 
Michael Kaplan claimed that once something was implemented in the
system tables, it was never changed. So, things may have been added,
but nothing that has ever existed is supposed to have been changed.
Do you have an example that would contradict what MichKa used to say
about that subject?
Click to expand...

Nope. I'd trust Michael on this one! I've never delved into the mysteries of
the MSys tables, and he has (deeply).
 
Back
Top