Tue Jan 08 13:30:32 GMT 2008

query table metadata

Several database using following query:

select column_name, numeric_precision as length, data_type from information_schema.columns where table_name='TEST'

H2, mysql and postgresql support above syntax

http://h2database.com/ipowerb/index.php?act=ST&f=2&t=205

There difference of getColumnName() and getColumnLabel() , for SQL "select name as n from table" getColumnName() with return "n" and getColumnLabel() will return "name" - http://ola-bini.blogspot.com[..]you-using-resultsetmetadatagetcolum.html


(google search) (amazon search)
1 2 3 second