Hi Eric,   Thanks once again, by updating the view I assume you mean running 'alter view' with the same complex SQL statement via the following process:   1) Run show table to get all the tables 2) Run describe view formatted over each table to see which are views and extract the corresponding complex SQL. 3) For each view, itterate over the complex SQL and determine if they it is selecting from any of the updated tables 4) For each view that needs updating run alter view for each view with the original complex SQL extracted in step 2.   I can code this up, but was wondering if there is another way.   ... View more