Altering a View

Views can typically not be altered; they must be dropped and recreated. You can:

1. Select the view in the Databases tree,
2. Double-click the view node to open its Object View tab,
3. Open the DDL sub tab,
4. Select Copy to New Editor from the DDL tab's right-click menu, which opens an SQL Commander tab with the DDL,
5. Remove the CREATE VIEW part in the SQL Commander editor so you are left with just the SELECT statement,
6. Load the SELECT statement into the Query Builder and alter it graphically,
7. Launch the Drop View assistant from the view node's right-click menu, and click Execute to drop it,
8. Create the new view from the altered SELECT statement.