How do I get a list of stored proceedures in my database?
Posted in 1999
Topics: General Discussion
How do I get a list of stored proceedures in my database? Someplace in the sysmaster I would think. Thanks david.tamburin@protegrity.com
David,
dbschema -f all -d [dbname]
will give you what you want.
Terry Hillick
VP, CSCSi
thillick@cscsi.com
David Tamburin wrote:
> How do I get a list of stored proceedures in my database?
> Someplace in the sysmaster I would think.
> Thanks
> david.tamburin@protegrity.com
In article <787p3b$t55$1@news.xmission.com>, david.tamburin@protegrity.com
(David Tamburin) wrote:
>
> How do I get a list of stored proceedures in my database?
> Someplace in the sysmaster I would think.
> Thanks
> david.tamburin@protegrity.com
>
Try
dbschema -d <database> -f all
I remember it as the F-All command but I'm a bit odd somedays
Paul Watson # I don't suffer from
WF Software Ltd. # stress, I'm just
Tel. (+44) 1436 674729 # a carrier
Fax. (+44) 1436 678693 #
www.wfsoftware.co.uk