Reading out Table information

Thread view:

Christian Decker - 21 Feb 2006 20:32 GMT

Hi,
I'm currently working on a synchronization tool using Java, it should
be flexible enough to read out the table details (columns, indices and
alike) on runtime and then check wether or not the destination is
compatible. The problem is that I was unable to find a (standard) way
to read out the index and the columns information of a table. Is there
a special JDBC Function or, even better, does the SQL standard define a
way to do that?

Thank you for your time,
Christian 'Snyke' Decker

--
http://www.Snyke.net

Reply to this Message

IchBin - 21 Feb 2006 21:00 GMT

Christian Decker wrote:

> Hi,
> I'm currently working on a synchronization tool using Java, it should
[quoted text clipped - 9 lines]
>
> --

You do it with java.sql.DatabaseMetaData;

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

Snyke - 22 Feb 2006 11:52 GMT

Thanks alot

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...