How to see the descriptions of all user defined columns in a database

June 24, 2013


 select
        st.name [Table],
        sc.name [Column],
        sep.value [Description],
        st.[type]
    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.type='U'

You Might Also Like

0 comments

Popular Posts

Twitter