Get List of Parameter of Stored Procedure in SQL Server

Jignesh Trivedi

11y929Code

This code snippet is for Get List of parameter of Stored Procedure in SQL Server.

Following SQL Query help us to retrieve list of parameter of specific stored procedure.

Use TestDB
select * from information_schema.parameters
where specific_name='TableName'