SELECT Object_name (ID) AS Name
, c.Name AS field name
, t.name data type
, C.PREC AS length
From syscolumns c
Inner Join
SYSTYPES T
On C.XUSERTYPE = T.XUSERTYPE
Where object_name (ID) = 'Table' - change table to your table name
Go
