MSSQL中查询某表中的字段信息

SELECT A.name AS table_name,		--表名
       B.name AS column_name,			--字段名
       C.value AS column_description,	--描述
       D.name AS column_type,			--字段类型
       B.max_length								--字段长度
FROM sys.tables AS A
    INNER JOIN sys.columns AS B
        ON B.object_id = A.object_id
    LEFT OUTER JOIN sys.extended_properties AS C
        ON C.major_id = B.object_id
           AND C.minor_id = B.column_id
    LEFT OUTER JOIN systypes D
        ON B.user_type_id = D.xusertype
WHERE (A.name = 't_bcp_icmoreport');