如何用SQL语句查询一个数据表所有字段的类型

SELECT   name AS column_name,TYPE_NAME(system_type_id) AS column_type,  max_length,is_nullableFROM sys.columnsWHERE object_id=OBJECT_ID(N'Product') order by name或exec sp_help '表名'