RECREATE VIEW

<< CREATE OR ALTER VIEW | FB 2.5 Language Reference | DML statements >>
<< CREATE VIEW | FB 2.1 Language Reference | DML statements >>
<< RECREATE TRIGGER | FB 2.0 Language Reference | REVOKE ADMIN OPTION >>

RECREATE VIEW

Available in: DSQL

Added in: 1.5

Description

Creates or recreates a view. If a view with the same name already exists, RECREATE VIEW will try to drop it and create a new view. RECREATE VIEW will fail if the existing view is in use.

Syntax

Exactly the same as CREATE VIEW.

See also:
View
CREATE VIEW
DROP VIEW

back to top of page
<< CREATE OR ALTER VIEW | FB 2.5 Language Reference | DML statements >>
<< CREATE VIEW | FB 2.1 Language Reference | DML statements >>
<< RECREATE TRIGGER | FB 2.0 Language Reference | REVOKE ADMIN OPTION >>