SQL 查看所有存储过程(MS SERVER、MySQL、Oracle)

SQL 查看所有存储过程(MS SERVER、MySQL、Oracle)

1、MS SERVER:

select * from sysobjects where type='tr'

2、MySQL SERVER:

select * from MySQL.proc

show procedure status;

3、Oracle:

select *From user_source;

  

  

 

创建时间:2021.12.27  更新时间:

博客园 滔Roy https://www.cnblogs.com/guorongtao 希望内容对你所有帮助,谢谢!
原文地址:https://www.cnblogs.com/guorongtao/p/15735553.html