Hi all, When altering a table the other day I discovered that any views that reference the table get dropped automatically (and silently), as do any views that depend on those views, and so on. This came as a nasty surprise to me when I tried to access one of those views!
If the table has associated triggers I get an error when I try to alter it, so I know which triggers are involved and I can then drop them and re-create them after the alteration. Shouldn't the same be true for views to avoid surprises? Or does the standard mandate this bizarre behaviour somewhere? I'd be glad to hear any informed opinions on this... ------------------------------------------------------------------------ John English | My old University of Brighton home page is still here: | http://www.cem.brighton.ac.uk/staff/je/ ------------------------------------------------------------------------