USP_SCHEMAINFO_GETPARAMETERINFO

Returns parameter information for a specific function or stored procedure.

Parameters

Parameter	Parameter Type	Mode	Description
@PROCEDURENAME	nvarchar(128)	IN
@SCHEMA	nvarchar(128)	IN

Definition

Copy



            create procedure dbo.USP_SCHEMAINFO_GETPARAMETERINFO 
            (
                @PROCEDURENAME nvarchar(128), 
                @SCHEMA nvarchar(128)='dbo'
            )
            as
                select 
                    PARAMETER_NAME, 
                    PARAMETER_MODE, 
                    ORDINAL_POSITION, 
                    DATA_TYPE, 
                    CHARACTER_MAXIMUM_LENGTH 
                from 
                    INFORMATION_SCHEMA.PARAMETERS 
                where 
                    SPECIFIC_SCHEMA=@SCHEMA and 
                    SPECIFIC_NAME=@PROCEDURENAME
                order by 
                    ORDINAL_POSITION