select syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length
from syscolumns,systypes
where syscolumns.xusertype=systypes.xusertype and syscolumns.id=OBJECT_ID('表名')
from syscolumns,systypes
where syscolumns.xusertype=systypes.xusertype and syscolumns.id=OBJECT_ID('表名')