The description of procedures is not transferred from mssql

[feride-sh]

Affected module
backend

Describe the bug
The procedure description is not pulled up, since the script has a filter for tables and views

MSSQL_GET_TABLE_COMMENTS = textwrap.dedent(
    """
SELECT obj.name AS table_name,
        ep.value AS table_comment,
        s.name AS "schema"
FROM sys.objects AS obj
LEFT JOIN sys.extended_properties AS ep
    ON obj.object_id = ep.major_id AND ep.minor_id = 0 AND ep.name = 'MS_Description'
JOIN sys.schemas AS s
    ON obj.schema_id = s.schema_id
WHERE
    obj.type IN ('U', 'V') /* User tables and views */ -- HERE. Only this code use 'sys.extended_properties'. Procedures is type 'P'
"""
)

Expected behavior
The description of the procedures is transferred and updated from mssql to omd

Version:

• OpenMetadata version: 1.6.2