CREATE PROCEDURE DisableTriggers(TableName VARCHAR)
BEGIN
   DECLARE TempCursor CURSOR FOR TempStatement;
   DECLARE TempTableName VARCHAR;
   DECLARE TempTriggerName VARCHAR;

   IF (COALESCE(TableName,'') <> '') THEN
      PREPARE TempStatement FROM 'SELECT * FROM Information.Triggers WHERE TableName=?';
      OPEN TempCursor USING TableName;
      FETCH FIRST FROM TempCursor (Name) INTO TempTriggerName;
      WHILE (NOT EOF(TempCursor)) DO
         EXECUTE IMMEDIATE 'DISABLE TRIGGER '+TempTriggerName+' ON '+TableName;
         FETCH NEXT FROM TempCursor (Name) INTO TempTriggerName;
      END WHILE;
   ELSE
      PREPARE TempStatement FROM 'SELECT * FROM Information.Triggers';
      OPEN TempCursor USING TableName;
      FETCH FIRST FROM TempCursor (TableName, Name) INTO TempTableName, TempTriggerName;
      WHILE (NOT EOF(TempCursor)) DO
         EXECUTE IMMEDIATE 'DISABLE TRIGGER '+TempTriggerName+' ON '+TempTableName;
         FETCH NEXT FROM TempCursor (TableName, Name) INTO TempTableName, TempTriggerName;
      END WHILE;
   END IF;
END
  