How do I view a stored procedure?

Question

You can find the stored procedure in the Object Explorer, under Programmability > Stored Procedures as shown in the following picture: Sometimes, you need to click the Refresh button to manually update the database objects in the Object Explorer.

How do I view a stored procedure in SQL?

First, run SQL Server Management Studio and connect to the Database Engine. Next, under Object Explorer, expand the database in which you have created a procedure, and then expand “Programmability” option. Next, expand “Stored Procedures”, right-click the procedure you want and then select “View Dependencies” option.

How do I view a stored procedure in Access?

Access 2010 has both stored procedures, and also has table triggers. For access 2010, you open up the table (non design view), and then choose the table tab. You see options there to create store procedures and table triggers.

How do I view a stored procedure in SQL Developer?

You can use the connections tab which is in the left side of sql developer. Show activity on this post. Browse to the connection name in the connections tab, expand the required object and just click, it will open the code in new tab.

Expert · Answer