Subject | Alter View |
---|---|
Author | ainpoissee |
Post date | 2005-06-06T19:40:41Z |
Hi!
I have to add an field into view. According to the LangRef (IB6) there
is no ALTER VIEW statement. In the FB1.5 ReleaseNotes (I'm using
FB1.5) there is RECREATE VIEW statement but it seems to be just
shortcut to avoid typing DROP VIEW? Ie it can't recreate view which is
used by an SP, I have to drop the SP before I can recreate the view?
If so then this is a major PITA... :(
Or is there any other way to add field into view?
TIA
ain
I have to add an field into view. According to the LangRef (IB6) there
is no ALTER VIEW statement. In the FB1.5 ReleaseNotes (I'm using
FB1.5) there is RECREATE VIEW statement but it seems to be just
shortcut to avoid typing DROP VIEW? Ie it can't recreate view which is
used by an SP, I have to drop the SP before I can recreate the view?
If so then this is a major PITA... :(
Or is there any other way to add field into view?
TIA
ain