Thanks, it's very very useful, defiantly going to bookmark it, but the my problem is its getting the values through java methods, but i preferably have to get it using a mySql statement?(almost the whole system is based like that) Any ideas??? Thanks
Maja Gralewska wrote: but i preferably have to get it using a mySql statement?(almost the whole system is based like that) Any ideas??? Thanks
I don't thinks that make any difference, JDBC drivers are vendor specific, so what are you doing using 'DatabaseMetadata' interface, internally it invokes the right procedure/select statement to fetch schema information..
I have been looking through the web including the official sun mySql page, and this is most probably my fault for not phasing my question perfectly.(sorry) I can get the type eg: VARCHAR 20 and the data eg: MONKEY and the size of monkey eg: 6, but what i am trying to get using a mySql statement is the 20. eg if in the table its set as VARCHAR 55 then i want to get only the 55 not the whole type, just the set size.