How to get stored procedure definition details in sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I want to get stored procedure details such as
Parameters, parameter data type, Is parameter has default value or not.
Also, i want to get stored procedure resulting column names.

Please help.

Posted 1-Sep-14 23:47pm

Ganesh11021423

Add a Solution

2 solutions

Solution 1

Try sp_help <procedurename>, if thats what you are after

Posted 1-Sep-14 23:52pm

Rocker-Star

Comments

Ganesh11021423 2-Sep-14 7:11am

Thanks Rocket-Star.
Excellent!!

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Animesh Datta · Accepted Answer · 2014-09-02T00:07:00

Solution 2

Hello ,
if you want to see the parameters, number of data types of any sp then simple select it and
press alt+F1 besides it if you want to get the definition of the sp then

sp_helptext 'sp_name'

thanks

Posted 2-Sep-14 0:07am

Animesh Datta

Comments

Ganesh11021423 2-Sep-14 7:10am

Thanks Animesh.

Animesh Datta 2-Sep-14 7:21am

welcome

How to get stored procedure definition details in sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

How to get stored procedure definition details in sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us