Ads 720 x 90

Query to return the parameters for a specified stored procedure or function

SELECT SCHEMA_NAME(schema_id) AS schema_name
 , AS object_name
 , AS parameter_name
 ,TYPE_NAME(p.user_type_id) AS parameter_type
FROM sys.objects AS o
INNER JOIN sys.parameters AS p ON o.object_id = p.object_id
WHERE o.object_id = OBJECT_ID('<schema_name.object_name>')
ORDER BY schema_name, o.object_name, p.parameter_id;

Related Posts

Total Pageviews

Subscribe Our Newsletter