I have an sql database with many views and stores procedures (nothing new I guess) some of the views are of other views. However when I change one of the lower views the views / sp's above do not reflect the changes in the bottom view unless I "Alter" it. Is there an easy way I can refresh all the views and stored procedures without having to edit and "Alter" each one.

Thanks Steve