Chinaunix
标题:
查看触发器和存储过程总结
[打印本页]
作者:
lgzbj2006
时间:
2009-11-04 10:54
标题:
查看触发器和存储过程总结
1、查看触发器的个数SELECT `TRIGGER_NAME` FROM `INFORMATION_SCHEMA`.`TRIGGERS` WHERE `TRIGGER_SCHEMA` = 'question_answer';2、查看所有触发器状态show triggers;3、删除触发器DROP TRIGGER `question_answer`.`t_weekStatistics_basic_user_i`;2、查看存储过程的个数SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'farm' AND ROUTINE_TYPE = 'PROCEDURE';
本文来自ChinaUnix博客,如果查看原文请点:
http://blog.chinaunix.net/u3/104127/showart_2085950.html
欢迎光临 Chinaunix (http://bbs.chinaunix.net/)
Powered by Discuz! X3.2