查詢資料庫欄位以及欄位描述

   SELECT
        st.name [Table],
        sc.name [Column],
        sep.value [Description]
    FROM sys.tables st
    INNER JOIN sys.columns sc on st.object_id = sc.object_id
    LEFT JOIN sys.extended_properties sep on st.object_id = sep.major_id
    AND sc.column_id = sep.minor_id
    AND sep.name = 'MS_Description'
    WHERE st.name = '資料表名稱'

輸出結果：

GHG_PROJECT_COMPANY DOC_MAINTAINER_PHONE 維護人員-聯絡電話
GHG_PROJECT_COMPANY DOC_MAINTAINER_ADDRESS 維護人員-聯絡地址
GHG_PROJECT_COMPANY DOC_MAINTAINER_DEPT_NAME 維護人員-部門
GHG_PROJECT_COMPANY DOC_MAINTAINER_NAME 維護人員-撰寫、保管與維護者
GHG_PROJECT_COMPANY DOC_MARKER_NAME 製作單位(人員)
GHG_PROJECT_COMPANY INSPECTION_INSIDE_ELIMINATE 內部查證-使用排除門檻(%)
GHG_PROJECT_COMPANY INSPECTION_INSIDE_COUNT_OF_YEAR 內部查證-本年度第幾次盤查
GHG_PROJECT_COMPANY INSPECTION_INSIDE_DATE 內部查證-查證時間
GHG_PROJECT_COMPANY INSPECTION_AGENCY_ELIMINATE 內部查證-使用排除門檻(%)
GHG_PROJECT_COMPANY INSPECTION_AGENCY_COUNT_OF_YEAR 內部查證-本年度第幾次盤查
GHG_PROJECT_COMPANY INSPECTION_AGENCY_DATE 內部查證-查證時間