查询和删除SQL存储过程SP

1.查询所有的存储过程

SELECT name AS procedure_name
    , SCHEMA_NAME(schema_id) AS schema_name
    , type_desc
    , create_date
    , modify_date
FROM sys.procedures;

2.删除

--DROP PROCEDURE [procedure_name];
--DROP PROCEDURE 存储的名称;
  DROP PROCEDURE  A_TEST;