Get List of Parameter of Stored Procedure in SQL Server

Following SQL Query help us to retrieve list of parameter of specific stored procedure.
  1. Use TestDB  
  2. select * from information_schema.parameters  
  3. where specific_name='TableName'