Monday, December 6, 2010

Mysql Triggers and Procedures syntax

To check Procedure :      SHOW PROCEDURE STATUS LIKE 'sp1'\G
To Check Triggers   :       SHOW TRIGGERS;
To See the Procedure :    SHOW CREATE PROCEDURE NameoftheProcedure

No comments: