db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Views dropped automatically when altering tables?
Date Tue, 07 Feb 2012 10:28:00 GMT
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/

View raw message