read out the SQL table structure

Select object_name (c.id) as table name
, C.name as field name
, T.name data type
, c.length length
, C.prec as Precision
, P.value as Field description
, M.text as defaults
, case when c.status=0x80 then 1 else 0 end identity
, c.iscomputed whether the column's flags have been computed
, c.isnullable whether null values are allowed
, c.isoutparam whether to output parameters
From syscolumns C
INNER JOIN systypes T on C.xusertype=t.xusertype
Left join Sysproperties p on c.id=p.id and c.colid = P.smallid
Left join syscomments m on c.cdefault=m.id
where OBJECTPROPERTY (c.id, ' isusertable ') =1 and object_name (c.id) = ' Dat_deptinfo '