View

Views are listed with tables in the Tables section of the left sidebar. Like a table, a view has three tabs at the bottom of the window: Data for its rows, Structure for its columns, and DDL for the SQL that defines it. Changes are kept locally until you press ⌘ + S¹ to commit them to the server.

Create view

1. Right-click the left sidebar and choose New > View, or click the arrow next to the + button at the bottom of the left sidebar and choose New View.
2. Enter the view name in the Name field.
3. Write the view's SELECT statement in the DDL editor.
4. Press ⌘ + S to create the view.

For PostgreSQL, Redshift, and Cassandra, you can also choose New > Materialized View.

Edit view

1. Open the view from the left sidebar.
2. Click DDL at the bottom of the window.
3. Edit the SQL code of the view. To rename the view, enter a new name in the Name field.
4. Press ⌘ + S to commit the change.

To see the view's columns, click Structure at the bottom of the window, or press ⌃ + ⌘ + ].

Materialized views can't be edited. Their DDL tab is read-only.

Delete view

1. Right-click the view in the left sidebar and choose Delete..., or select it and press Delete.
2. Press ⌘ + S to commit the change.