>I need to determine the size of numeric fields in SQL tables. I know how to get the decimal positions but I cannot find out how to determine the significant positions. Some thing like Numeric(???,4) I need to determine the ??? value. How can I retrieve this information from the SQL schema?
>
>Thanks
>
>Glenn
SELECT NUMERIC_PRECISION,
NUMERIC_SCALE
FROM INFORMATION_SCHEMA.Columns
WHERE Table_Name = 'YourTable' AND
Column_Name = 'ColumnName'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.