Where can I see list of SPs also where have my comments gone?

[David Green]

Hi,

I'm an experienced Sybase developer moving to MySQL5 and am having loads of issues with stored procs - key ones at the moment:-

1. How do I report see the stored procs the database has within it? Is this part of query browser or is there a query I need to run myself to see these? Is there a tree-view within Query Browser to see these?

2. Much more seriously - where have my comments gone??? I've been using a different database browsing tool than Query Browser and can see the stored procs, although there are other issues with this system so can't use it exclusively. In this system I can view sp 'properties' and all my comments have vanished. Are they still there or are they stripped from the procs when they are inserted into the db?

Thanks,

David