> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/database-objects/view.md).

# View

## **Create view**

To create a new view:

* Right click on the left sidebar and choose **`New`** > **`View`**.
* Name the view and write the SQL command.
* After you finish, press **`⌘ + S`** to commit changes to the server.

![](/files/-Lrt283efsdRAvaxd61G)

## **Edit view**

To edit an existing view:

* Select to open the view from the left sidebar
* Switch to the structure tab by clicking on the **`Structure`** button at the bottom, or use shortcut key **`⌘ + ^ + ]`**.
* Edit the SQL code of the view.
* After you finish, press **`⌘ + S`** to commit changes to the server.

## **Delete View**

To delete a view, right click on view name on the left sidebar and choose **`Delete`**, or select the view and press **Delete** key.