I need a very simple documentation of tables: column name, length, datatype. The reason for this is so an admin can provide this for a couple hundred tables that user level report writers will use.
I wrote a small query to return this but the datatype is a number. Has anyone ever put together a table of datatype number - datatype name or can point me to what table the datatype names are stored in where I can pull the datatype name from
TIA
Doug Steinschneider