sp_procedure_params_managed (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_procedure_params_managed(nvarchar @procedure_name
, int @group_number
, nvarchar @procedure_schema
, nvarchar @parameter_name)

MetaData:

   
create procedure sys.sp_procedure_params_managed  
(  
    @procedure_name     sysname,  
    @group_number        int = 1,  
    @procedure_schema    sysname = null,  
    @parameter_name     sysname = null  
)  
as  
    select  
        PROCEDURE_CATALOG,  
        PROCEDURE_SCHEMA,  
        PROCEDURE_NAME,  
        PARAMETER_NAME,  
        ORDINAL_POSITION,  
        PARAMETER_TYPE,  
        PARAMETER_HASDEFAULT,  
        PARAMETER_DEFAULT,  
        IS_NULLABLE,  
        DATA_TYPE,  
        CHARACTER_MAXIMUM_LENGTH,  
        CHARACTER_OCTET_LENGTH,  
        NUMERIC_PRECISION,  
        NUMERIC_SCALE,  
        DESCRIPTION,  
        TYPE_NAME,  
        LOCAL_TYPE_NAME,  
        XML_CATALOGNAME             = SS_XML_SCHEMACOLLECTION_CATALOGNAME,  
        XML_SCHEMANAME                = SS_XML_SCHEMACOLLECTION_SCHEMANAME,  
        XML_SCHEMACOLLECTIONNAME    = SS_XML_SCHEMACOLLECTIONNAME,  
        UDT_CATALOG                 = SS_UDT_CATALOGNAME,  
        UDT_SCHEMA                    = SS_UDT_SCHEMANAME,  
        UDT_NAME                    = SS_UDT_NAME  
      
    from  
        sys.fn_procedure_params_90_rowset(  
            @procedure_name,  
            @group_number,  
            @procedure_schema,  
            @parameter_name)  
  
    order by 2, 3, 5  
    option (OPTIMIZE CORRELATED UNION ALL)