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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
What exactly is xbase? – a_horse_with_no_name Jun 12 '13 at 11:20

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

Your Answer


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.