"Martijn Tonies" wrote:

>
>>> Is there any prospect of being able to alter views? We use views and
>>> database access rights to enforce security but to change a view now
>>> involves dropping a large number of dependent views and SPs then
>>> granting privileges. This is prone to introducing error.
>>
>> Firebird v1.5 introduces a new statement "RECREATE VIEW"
>
> And how exactly is this going to help him? Isn't this a shorthand for
> DROP, CREATE? And don't throw errors if it doesn't exist?

ALTER VIEW will be supported in FB 1.5. I've partially implemented it, but
there's some extra work to be done to allow this in public builds, so it's
hidden so far. I expect it to be available for testing in January.


Dmitry