[DB-SIG] table metadata available?

Anthony Baxter Anthony Baxter <anthony@interlink.com.au>
Wed, 01 May 2002 09:25:45 +1000


>>> Danny Yoo wrote
> Hi everyone,
> 
> I hope I'm not bothering too much!  I'm starting to work on some tools
> that try to probe databases a bit dynamically.  Is there an API to pull
> the table definitions?  In particular, it'd be nice to be able to discover
> the primary keys of each table.  I can't see a way of doing this reliably
> with just the DB 2.0 API, but perhaps I'm just missing something obvious.

This is pretty database specific. Most grown-up databases make this
information available in various system tables. I can supply some SQL
for Oracle, if it would help.

Anthony

-- 
Anthony Baxter     <anthony@interlink.com.au>   
It's never too late to have a happy childhood.