Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to view the code of my xbase stored procedures.

I recognize that show procedures gives me the list of procedures.

Can anyone instruct me on how to get the actual code for the stored procedures?

share|improve this question
1  
You question says xbase, but you tagged it Sybase. Can you please clarify what you are looking for? –  Michael Gardner Jun 12 '13 at 11:01
1  
What exactly is xbase? –  a_horse_with_no_name Jun 12 '13 at 11:20
add comment

1 Answer 1

in Sybase ASE:

  • sp_helptext sp_name in your database can give you the code of the stored procedure
  • select * from sysobjects where type='P' in your database can list the stored procedures
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.