I need to display the table properties for a given table (of any DB type) and display the field sizes for each field in the table.
How can I firstly determine the actual size of the field. Secondly, if the field is of floating point type, how do I know it's precision?
If I created a table like this:
create table TEST (
I want to see something that looks like this:
Field1 Character 40
Field2 Floating 15 4
Field3 Integer 4*
*I'm only using four because that's the actual memory size required for an integer type. If there is a true size for the field it would be great, otherwise 4 is fine.
Any help would be greatly appreciated.