方式一:@参考博客 select * from sys.procedures WHERE name = 'proc_name' 方式二:@参考博客 select * FROM sys.all_objects where type_desc = N'SQL_STORED_PROCEDURE' and name = 'proc_name'; 转载于:https://www.cnblogs.com/yanan7890/p/9448414.html