Chinaunix

标题: How to drop all store procedure at a time? [打印本页]

作者: cwno1    时间: 2007-05-25 17:54
标题: How to drop all store procedure at a time?
I want to drop a lot of store procedure but I don't know how to set the parameter of DROP PROCEDURE <?>

I can use :

STRSQL--->DROP PROCEDURE + <Name storeprocedure>

to drop them one by one but it is so slow~~~~


Are there anyway to see the store procedure's list?

I can't see them using WRKOBJPDM
作者: 胖老头    时间: 2007-05-25 18:11
QSYS2/procedures库中有所有的存储过程
作者: qingzhou    时间: 2007-05-25 18:57
You also can use Navigator to view all user define store procedure




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2