How to view Stored Procedures in Squirrel

Question

Would like to know if one can view stored proc is Squirrel. Is there a plugin for this?

Solution 1

What version of SQuirreL are you working on ?..

I have 3.2.1 and all I need to do is click on "Objects" tab, expand your connection, look for your database, expand it, and then look for "Procedure" then click on the procedure you want, and then click on the "Source" tab

Solution 2

You have to install your correspondent database plugin. In case of sqlserver, you can install it with squirrel-sql installation by checking Microsoft SQL-Server Plugin as per below:

.

So once installed, you can:

• Right click on the stored procedure in the left menu,
• Select sql server from the drop down menu,
• Then select script procedure from the sub-menu

Here is a screenshot:

Solution 3

An easy way to get Stored Procedures source code on Ingres database:

select
    procedure_name, text_sequence, text_segment
from
    iiprocedures
where
    procedure_name = 'sp_name_goes_here'
order by
    text_sequence

Aloha!

Comments

[OscarRyz]

Do you have a plugin for that?