[Solved] List of stored procedures inside a database

by


The following query will list all user defined stored procs (including their parameters and parameter types) in your default database:

SELECT
  sp.name,
  p.name AS Parameter,
  t.name AS [Type]
FROM
 sys.procedures sp
  LEFT JOIN sys.parameters p
    ON sp.object_id = p.object_id
  LEFT JOIN sys.types t
    ON p.system_type_id = t.system_type_id
WHERE 
  is_ms_shipped = 0 
ORDER BY
  sp.name

Put that into an ADOQuery object and set it to Active. (Updated answer with LEFT JOINS so that it includes SPs without parameters).

solved List of stored procedures inside a database