删除触发器,DROP TRIGGER trigger_name;当然你要有相关权限。装个pl/sql,更简单。删除表的时候“应该”不会删除响应的触发器的。为验证,你可以验证下,记得验证了告诉偶哈。验证方法:删除表后查询相关触发器:语句SELECT TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT, TABLE_OWNER, BASE_OBJECT_TYPE, REFERENCING_NAMES, STATUS, ACTION_TYPE FROM all_triggerswhereTRIGGER_NAME=your_trigger_name;
1200字范文,内容丰富有趣,写作的好帮手!