how to display the table structure?

[perisekar]

hi all!

how we can display the table structure thru java gui?

means if a perticular user logs in then the list of objects or tables owned by him will be shown in a window,
if the user clickes any one of that it should display the structure!


regards!!!

[srinivast]

Sekhar,

You should use the getMetaData method from the Connection object and get the metadata. Once you have this metadata object you can get any information from the database catalog, using the various methods like getTables, getColumns and so on.

Srinivas. T

[perisekar]

Thanks a bunch srinivas!
it works fine....

regards!