identify primary key

Hi all, does any one knows how do I identify the primary key column(s) when a ResultSet is given?Thanks.

[125 byte] By [ken0624700] at [2007-9-26 4:06:47]

# 1

Hi!

you can use a java.sql class that retrieve all information regarding your database:

DatabaseMetaData

Check at:

http://java.sun.com/j2se/1.3/docs/api/java/sql/DatabaseMetaData.html

You can use ResultSetMetaData too:

ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");

ResultSetMetaData rsmd = rs.getMetaData();

int numberOfColumns = rsmd.getColumnCount();

boolean b = rsmd.isSearchable(1);

sylvain.barbot at 2007-6-29 13:07:28 >

Database Connectivity New Topic