Posted by Dirk Van de moortel on 01/11/06 20:57

"Paul" <paulNO_SPAM@yahoo.com> wrote in message news:Hacxf.78873$XC4.28023@twister.nyroc.rr.com...
> Hello,
>
> I only have remote access to the db via textual interface.
>
> Now I try to find out what an existing stored procedure is doing.
> I tried like 'desc sp_sale_pro' and 'show sp_sale_pro' - but that is not
> working.
>
> Can anybody help?
>
> Thanks!!
> Paul

select Routine_definition
from Information_Schema.Routines
where Routine_name = 'sp_sale_pro'

Dirk Vdm

[Back to original message]