How do I programmatically get column information of a table?

[To advertise Java(tm) Events here, contact joris@esus.com!]

Java™
by example!

	Login
	Login here Become a member only $14.95/year!

	New @ Esus.com
	In-house search engine for better results! Get updates with the esus.com newsletter!

Home

Browse Categories

Ask a Java Question

Help

For Java Tips & Tricks, subscribe to the esus.com newsletter!

Search Java Q&A, Links, API's: adv

Index:Java 2 Enterprise Edition (J2EE):JDBC

Printer-friendly version

How do I programmatically get column information of a table?

You can get meta information on a table by invoking getMetaData on a connection. With the method getColumns, you get back a number of rows containing information about each column of a particular table. Check the api to see what you can query.

Main.java:

This code sample is only viewable to esus.com members Login or become a member!

outputs:

This code sample is only viewable to esus.com members Login or become a member!

Further Information

Author of answer: Joris Van den Bogaert

Comments to this answer are only viewable by members. Login or become a member!