UFN_GETINDEXEXTENDEDPROPERTIES_FORTABLE

create function bbdw.UFN_GETINDEXEXTENDEDPROPERTIES_FORTABLE(
    @TABLENAME sysname
)
returns table
as return

    select
        ep.Name NAME,
        ep.value VALUE,
        'SCHEMA' LEVEL0TYPE,
        schema_name(schema_id) LEVEL0NAME,
        'TABLE' LEVEL1TYPE,
        T.name LEVEL1NAME,
        'INDEX' LEVEL2TYPE,
        I.name LEVEL2NAME
    from 
        sys.extended_properties as ep
        inner join sys.indexes as I on ep.major_id = I.object_id AND ep.minor_id = I.index_id
        inner join sys.tables as T on T.object_id = I.object_id
    where
        class = 7
        and 
        I.is_primary_key = 0 
        and I.is_unique_constraint = 0  
        and I.type not in (0, 1)
        and I.Object_id = object_id(@TABLENAME)