You should be able to get the information from INFORMATION_SCHEMA.Columns or other systems views, say, sys.Columns in SQL Server.
>Thanks Bonnie,
>
>Interesting though. If you can define anything (decimal places) in the database environment, you should be able to retrieve it one way or another no?
>
>If I remember correctly, "decimal places" is supported by standard SQL no?
>
>It's probably me.
>
>Thanks and kind regards,
>
>Marc
>
>PS : I totally agree that decimal places is not a storage but a formatting issue. Is it blasphematory then to want to define formatting at the DB level?
>
If it's not broken, fix it until it is.
My Blog