Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

where are stored procedures stored?

Status
Not open for further replies.
WiccaChic

WiccaChic

Technical User
Jan 21, 2004
179
US
How can I see the code for a stored procedure?
 
Sort by date Sort by votes
take a look at the sysprocbody table in your DB
 
Upvote 0 Downvote
Easiest way is:

dbschema –d <db_name> –f <proc_name>
dbschema –d <db_name> -f \all
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kray4660
  • Locked
  • Question
Stored Procedure attempt
Replies
0
Views
266
kray4660
kray4660
kookie15120
  • Locked
  • Question
Informix Stored Procedure
Replies
2
Views
286
kookie15120
kookie15120
aft5425
  • Locked
  • Question
All of the columns in my form are not showing
Replies
0
Views
166
aft5425
aft5425
MarcAureleSeverus
  • Locked
  • Question
Writing into Files from Stored Procedures
Replies
1
Views
257
PHV
PHV
evgeniosc
  • Locked
  • Question
How to Add a New Line in a Varchar in a Stored Procedure (SPL)
Replies
0
Views
200
evgeniosc
evgeniosc

Part and Inventory Search

Sponsor

Back
Top