How to view Stored Procedures in Squirrel

database squirrel-sql
sonx picture sonx · Feb 28, 2012 · Viewed 20k times · Source

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

Answer

JCarlos picture JCarlos · May 19, 2012

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

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More