How to get the table column names

[Mathews P Srampikal]

How to get table column name using ResultsetMetadata if there is no record present in the table.Thanks

[Lasse Koskela]

I don't think having an empty resultset prevents you from accessing the ResultSetMetaData object. Have you tried it?

[Sainudheen Mydeen]

You can get the column names from ResultSetMetaData even if your resultset is empty. For example if your quey is

select * from table_a where 1 = 2   

Still you will be able to get column names from the corresponding ResultSetMetaData.

-Sainudheen