获取某表所有列名和字段类型

Select sc.[name],st.[name] From SysColumns sc Left Join SysTypes st On sc.XUserType=st.XUserType Where id=object_id('T_User')