agentmail_drop.sql

/*
  AgentMail drop script.

  Drops all schema-level objects created by the AgentMail install scripts,
  EXCEPT the network ACL, which is managed separately by a DBA via run_as_admin.sql.

  Run this as the same schema that owns the AgentMail objects.
*/

set define off;

-- Test harness and helper package
DROP PROCEDURE AGENTMAIL_TEST_SUITE_BETA;
DROP PACKAGE   AGENTMAIL_TEST;

-- Main AgentMail package
DROP PACKAGE BODY AGENTMAIL;
DROP PACKAGE      AGENTMAIL;

-- Configuration package (values can be recreated from agentmail_config.sql or secrets.sql)
DROP PACKAGE AGENTMAIL_CONFIG;

-- Tables and type created by agentmail_schema.sql
DROP TABLE AGENTMAIL_ATTACHMENT_CONTENT;
DROP TABLE AGENTMAIL_MESSAGE_DETAIL;
DROP TABLE AGENTMAIL_ATTACHMENTS;
DROP TABLE AGENTMAIL_RECIPIENTS;
DROP TABLE AGENTMAIL_MESSAGES;
DROP TABLE AGENTMAIL_INBOXES;
DROP TABLE AGENTMAIL_API_TOKEN;

DROP TYPE LABEL_ARRAY;

-- Utility helpers from agentmail_utils.sql
DROP PROCEDURE DROP_TABLE;
DROP PROCEDURE ADD_PRIMARY_KEY;
DROP FUNCTION  DOES_CONSTRAINT_EXIST;
DROP FUNCTION  DOES_TABLE_EXIST;
DROP FUNCTION  DOES_OBJECT_EXIST;
DROP PROCEDURE DROP_OBJECT;