Subject RE: [firebird-support] Recreate a view that has dependencies
Author Alan McDonald
> Is there a way to recreate a view/ StoredProc without dropping
> all other vies/SPs that refer it?
> Thanks,
> Nick

some tools will create drop and create scripts for the views and SPs which
depend on it. If the dependiency chain is not too long and you do not hit a
spot where data loss is required, then they offer a clean way to create an
update script.