删除文档中所创建的表、触发器、视图、存储过程等数据

要删除文档中所创建的所有数据库对象（包括表、触发器、视图、存储过程），可以按照以下步骤进行：

### 删除表
首先需要删除所有的表，并且确保级联删除依赖于这些表的对象（如外键约束）。

DROP TABLE Enrollment CASCADE CONSTRAINTS;
DROP TABLE Class CASCADE CONSTRAINTS;
DROP TABLE Trainer CASCADE CONSTRAINTS;
DROP TABLE Course CASCADE CONSTRAINTS;
DROP TABLE Member CASCADE CONSTRAINTS;

### 删除视图
接下来删除所有的视图。

DROP VIEW v_Course;
DROP VIEW v_Enrollment;
DROP VIEW v_DetailedMember;
DROP VIEW v_DetailedTrainer;
DROP VIEW v_MemberCourses;
DROP VIEW v_MaleMembers;
DROP VIEW v_PartClass;
DROP VIEW v_PartTrainer;
DROP VIEW v_Member;

### 删除触发器
然后删除所有的触发器。

DROP TRIGGER before_enroll;
DROP TRIGGER after_delete_Class;
DROP TRIGGER instead_of_Enrollment;
DROP TRIGGER cascade_delete_Course;
DROP TRIGGER trig_drop_objects;

### 删除存储过程
最后删除所有的存储过程。

DROP PROCEDURE print_welcome_message;
DROP PROCEDURE list_all_courses;
DROP PROCEDURE get_member_info;
DROP PROCEDURE get_course_info;
DROP PROCEDURE get_member_info_out;
DROP PROCEDURE get_trainer_info_out;
DROP PROCEDURE p_stuinfo;
DROP PROCEDURE p_stuinfo2;
DROP PROCEDURE p_swap;

### 完整的删除脚本
将上述所有命令整合到一个完整的脚本中：

-- 删除表
DROP TABLE Enrollment CASCADE CONSTRAINTS;
DROP TABLE Class CASCADE CONSTRAINTS;
DROP TABLE Trainer CASCADE CONSTRAINTS;
DROP TABLE Course CASCADE CONSTRAINTS;
DROP TABLE Member CASCADE CONSTRAINTS;

-- 删除视图
DROP VIEW v_Course;
DROP VIEW v_Enrollment;
DROP VIEW v_DetailedMember;
DROP VIEW v_DetailedTrainer;
DROP VIEW v_MemberCourses;
DROP VIEW v_MaleMembers;
DROP VIEW v_PartClass;
DROP VIEW v_PartTrainer;
DROP VIEW v_Member;

-- 删除触发器
DROP TRIGGER before_enroll;
DROP TRIGGER after_delete_Class;
DROP TRIGGER instead_of_Enrollment;
DROP TRIGGER cascade_delete_Course;
DROP TRIGGER trig_drop_objects;

-- 删除存储过程
DROP PROCEDURE print_welcome_message;
DROP PROCEDURE list_all_courses;
DROP PROCEDURE get_member_info;
DROP PROCEDURE get_course_info;
DROP PROCEDURE get_member_info_out;
DROP PROCEDURE get_trainer_info_out;
DROP PROCEDURE p_stuinfo;
DROP PROCEDURE p_stuinfo2;
DROP PROCEDURE p_swap;

执行以上脚本即可彻底删除文档中创建的所有数据库对象。