Subject | Alter views with dependencies |
---|---|
Author | rj1102 |
Post date | 2005-03-11T08:13:34Z |
One big problem with views is that you can not alter a view if there
are other views dependent on it.
You have to drop all dependent views (and views that are dependent on
the dependent views, etc), then alter the main view and create all
dependent views again.
Is there a tool to do this automatically?
Or even better: are there plans to support the alteration of views
with dependecies?
I have already seen a Request for Enhancement/Feature for this in the
tracker (#807979), but it seems very old and forgotten.
In most cases the dependencies after the alteration of the view are
the same as before the alteration (f.e. in case I only change the
where clause or add fields to the select clause). So maybe it is
hopefully:) not too difficult to change Firebird to support this
cases.
Thanks,
Robert
are other views dependent on it.
You have to drop all dependent views (and views that are dependent on
the dependent views, etc), then alter the main view and create all
dependent views again.
Is there a tool to do this automatically?
Or even better: are there plans to support the alteration of views
with dependecies?
I have already seen a Request for Enhancement/Feature for this in the
tracker (#807979), but it seems very old and forgotten.
In most cases the dependencies after the alteration of the view are
the same as before the alteration (f.e. in case I only change the
where clause or add fields to the select clause). So maybe it is
hopefully:) not too difficult to change Firebird to support this
cases.
Thanks,
Robert