在对数据库进行结构更改后更新MySQL存储过程

I would appreciate any help on this problem. I am running a website which uses MySQL database. I built the database model in MySQL Workbench and all SQL-queries are stored procedures. The problem is that when I make structural changes to the database, I do not know which stored procedures get affected, so I have either to manually list through all the procedures and manually make changes, or use the try-and-error method. The question - is there a way to automate stored procedures update process. I want to know exactly what stored procedures get affected when making certain structural changes to the database. If it is not possible with MySQL, then is it possible with other databases? (open-source or commercial). Thank you.I would appreciate any help on this problem. I