Listing All Stored Procedures Parameters of ALL Databases in SQL Server
In this blog we see, How to list all the Stored Procedures Parameters from all the database 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.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: