just wanted to complete this thread by pointing out that sysdepends is not reliable and in some cases when you drop / create objects not in a correct order then...

thx that's what i've been doing on one ugly database i have to manage which is filled with views, i am using a fixed 2 level down search knowing there...

thx for the tips

i have one question on the same topic though, am i right in assuming that if you have nested views (inside views) you will have to update...