CODEWITHSUNDEEP
databasesquirrel-sql
sonx
sonx

Reputation: 661

How to view Stored Procedures in Squirrel

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

Upvotes: 3

Views: 24226

Answers (4)

Renato Mestre
Renato Mestre

Reputation: 66

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!

Upvotes: 1

hd84335
hd84335

Reputation: 9893

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:

sqlserver plugin.

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:

enter image description here

Upvotes: 2

Ryan D
Ryan D

Reputation: 1113

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.

Upvotes: 0

JCarlos
JCarlos

Reputation: 51

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

Upvotes: 2

Related Questions