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 Rhinorhino 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
Joined
Jan 21, 2004
Messages
179
Location
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 Question
Stored Procedure attempt
Replies
0
Views
434
kray4660
kray4660
kookie15120
  • Locked
  • Question Question
Informix Stored Procedure
Replies
2
Views
410
kookie15120
kookie15120
aft5425
  • Locked
  • Question Question
All of the columns in my form are not showing
Replies
0
Views
214
aft5425
aft5425
MarcAureleSeverus
  • Locked
  • Question Question
Writing into Files from Stored Procedures
Replies
1
Views
349
PHV
PHV
evgeniosc
  • Locked
  • Question Question
How to Add a New Line in a Varchar in a Stored Procedure (SPL)
Replies
0
Views
259
evgeniosc
evgeniosc

Part and Inventory Search

Sponsor

Back
Top