Subject RE: [ib-support] CREATE OR REPLACE Oracle equivalent
Author Dmitry Yemanov
Hi,

> There is a RECREATE table/procedure - don't know about views
> - Have a go at it.

1) RECREATE VIEW doesn't exist
2) RECREATE is not the same thing as CREATE OR REPLACE. RECREATE is a
shorthand for DROP/CREATE, whilst CREATE OR REPLACE is a conditional
CREATE/ALTER depending on the object existance.

So, there's no such equivalent in FB. But it's already logged as a feature
request, so it will appear in the next FB versions. Let's say, in FB 2.0 ;-)


Dmitry