MySQL我想找存储过程是否存在?

Question

问题遇到的现象和发生背景

1.首先我找到了
if exists (select * from sysobjects where id = object_id(N’[存储过程名]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1) 这个
但是 select * from sysobjects where id = object_id(N’[存储过程名]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1
执行这句话时执行不成功

问题相关代码，请勿粘贴截图

select * from sysobjects where id = object_id(N’[tes_pro]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1
select * from sysobjects where id = object_id(N’["tes_pro"]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1
select * from vnumdb.sysobjects where id = object_id(N’vnumdb.tes_pro’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1

运行结果及报错内容

上面的这几种写法都不成功,其中第三个提示 vnumdb.sysobjects 不存在

Answer 1

select* from sysobjects where name＝存储过程名(存储过程名用单引号引住