UFN_SCHEMA_TABLE_GETTABLECOMMENT

CREATE function dbo.UFN_SCHEMA_TABLE_GETTABLECOMMENT(@TABLENAME nvarchar(128)) returns nvarchar(4000)
with execute as caller
as

begin

    declare @value nvarchar(4000);

    --select @value = cast(value as nvarchar(4000)) from fn_listextendedproperty(N'MS_Description', N'SCHEMA', N'dbo', N'table', @TABLENAME, default, default);

    select @value = cast(ep.value as nvarchar(4000)) from 
    sys.extended_properties as ep 
    where ep.[class]=1  and ep.major_id=OBJECT_ID(@TABLENAME) and ep.minor_id=0 and ep.[name] = N'MS_Description';


    select @value = case when @value is null then '' else @value end;

    return @value;
end