SQL Server 查詢表備注信息的語句

--name???字段名稱
--user_type_id?
--max_length?最大長度
--is_nullable?是否允許空
--remark??描述
SELECT c.name, c.user_type_id, c.max_length, c.is_nullable, remark = ex.value
FROM sys.columns c inner JOIN? sys.extended_properties ex
ON
?? ex.major_id = c.object_id?
?? AND ex.minor_id = c.column_id??
?? AND ex.name = 'MS_Description'??
WHERE??
?? OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0??
?? AND OBJECT_NAME(c.object_id) = 't_tableName'
ORDER??
?? BY OBJECT_NAME(c.object_id), c.column_id