USP_SCHEMA_TABLE_CLEARCOLUMNCOMMENT

CREATE procedure [dbo].[USP_SCHEMA_TABLE_CLEARCOLUMNCOMMENT]

    @TABLENAME [nvarchar](128),
    @COLUMNNAME [nvarchar](128)

    with execute as caller

    as

    if exists (    
        --select value from fn_listextendedproperty(N'MS_Description', N'SCHEMA', N'dbo', N'table', @TABLENAME, N'COLUMN', @COLUMNNAME)
        select ep.value 
        from sys.extended_properties as ep
        inner join sys.columns as c on c.object_id=ep.major_id and c.column_id=ep.minor_id
          where 
          ep.class=1
          and
          ep.major_id=OBJECT_ID(@TABLENAME,'U')
          and 
          ep.minor_id > 0
          and
          ep.[name] = N'MS_Description'
          and 
          c.[name]=@COLUMNNAME

    )
        exec sp_dropextendedproperty N'MS_Description', N'SCHEMA', N'dbo', N'table', @TABLENAME, N'COLUMN', @COLUMNNAME;