0

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?

2
  • 1
    You question says xbase, but you tagged it Sybase. Can you please clarify what you are looking for? Jun 12, 2013 at 11:01
  • 1
    What exactly is xbase?
    – user1822
    Jun 12, 2013 at 11:20

1 Answer 1

4

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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