Selecting the length of a column?

[pdbowling]

Good day,
I would like to query from myTable the length that is used to set the length of a column when building the table.

ie:

if myColumn is a varchar(20),
can I select in sql in some manner to get 20 back as a result?

Thanks everyone.
PB


Patrick is a distributor of Republic Magazine (

http://www.RepublicMagazineKy.com

-free pdf copy downloadable ) and the webmaster of

http://www.LibertyArticles.com

 

[JohnDTampaBay]

What version of SQL Server are you running? This should work for 2000 and higher.

SELECT Character_Maximum_Length
FROM Information_Schema.Columns
WHERE Table_Name = 'myTable'
AND Column_Name = 'myColumn'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[pdbowling]

Its SQL 2005 and this works great, thank you.
P

Patrick is a distributor of Republic Magazine (

http://www.RepublicMagazineKy.com

-free pdf copy downloadable ) and the webmaster of

http://www.LibertyArticles.com