Subject Detect all currency field in a database
Author svanderclock

I want to know if it's possible to detect all currency field in a database? for now i use this "trick": only currency field are Numeric(15,5) but i just want to know if their is no better way to put a "flag" or a comment on a field to indicate that it's store currency ?

Also how to make a storedprocedure that will update in a database ALL field that are Numeric(15,5) ?

thank you by advance