How to get ColumnNames, datatypes and length

select  sc.name as ColumnName,  st.name as ColumnDatatype,  convert(int, sc.length) as columnLength
from syscolumns sc, sysobjects so , systypes st
where so.type='U' and so.name='Authors' and sc.id=so.id
and st.xusertype=sc.xusertype