GET MAX COLUMN SIZE

[chrisdq]

Hi,


Does anyone know how to find out the max size of characters of a column using SQL query?

Sometimes people enter characters that exceed the max size of a column and SQL returns an error. I want to do a check first and give people a friendly error.



Thanks in advance,
Chris.

 

[gmmastros]

Run this in Query Analyzer.

Select * from Information_Schema.Columns

There should be a Character_Maximum_Length column that you can use.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[chrisdq]

gmmastros,

Thanks for the your very helpful tip, however Information_Schema.Columns doesn't seem to show the max size for digits.

 

[SQLDenis]

Look at the NUMERIC_PRECISION and NUMERIC_SCALE columns

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/