In this blog we see, How to list all the Stored Procedures Parameters from all the database in sql server.
Listing All Stored Procedures Parameters of ALL Databases in SQL Server
? – Indicates the name of database.
This will iterate all the database in the sql server and list the sys Stored Procedures Parameters as section based on the database.
sp_msforeachdb 'select "?" AS dbName, * from [?].sys.parameters
You can also use like below,
select * from [DatabaseName].sys.parameters
Thanks for reading this article. Have a nice day.