how to view content of xbase procedures?

Question

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?

You question says xbase, but you tagged it Sybase. Can you please clarify what you are looking for? — Michael Gardner, Jun 12, 2013 at 11:01

Kin Shah · Accepted Answer · 2013-06-13 16:38:10Z

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

Kin Shah

62k6 gold badges119 silver badges235 bronze badges

answered Jun 12, 2013 at 13:33

Vince

2211 gold badge2 silver badges5 bronze badges

Add a comment |

1 Answer 1