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?

Did you try SQuirreL SQL Client Version 3.7? – Neeraj Singh Sep 18 '15 at 18:27 — Neeraj Singh, Sep 18 '15 at 18:27

score 2 · Answer 1 · answered May 18 '12 at 22:35

2

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

answered May 18 '12 at 22:35

JCarlos

51
1
8

Do you have a plugin for that? – OscarRyz Oct 29 '12 at 16:55

score 2 · Answer 2 · answered Feb 23 '18 at 17:25

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:

score 1 · Answer 3 · answered May 15 '18 at 21:00

1

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!

answered May 15 '18 at 21:00

Renato Mestre

46
6

score 0 · Answer 4 · answered Apr 05 '16 at 15:22

0

Using SQuirreL 3.5.2, I knew there should be Procedures in our database but they were not showing by default. I right-clicked the Procedures and chose "Refresh Item" to get them to show. Must not be loaded by default so that can be misleading.

answered Apr 05 '16 at 15:22

Ryan D

1,023
11
16

How to view Stored Procedures in Squirrel

4 Answers4