Transact-SQL to get description of column in Sql Server 2005 using fn_listextendedproperty

Transact-SQL to get the description property of the column in sql server 2005 using fn_listextendedproperty

select value from ::fn_listextendedproperty ('MS_Description', 'user',
'dbo', 'table', 'usermaster', 'column', 'password')

'usermaster' – is the table name
'password' – is the column name

"fn_listextendedproperty" returns extended property values of database objects. If the value for property_name is NULL or default, fn_listextendedproperty returns all the properties for the specified object.

"fn_listextendedproperty" Syntax

fn_listextendedproperty ( 
    { default | 'property_name' | NULL } 
    , { default | 'level0_object_type' | NULL } 
    , { default | 'level0_object_name' | NULL } 
    , { default | 'level1_object_type' | NULL } 
    , { default | 'level1_object_name' | NULL } 
    , { default | 'level2_object_type' | NULL } 
    , { default | 'level2_object_name' | NULL } 
    )