> 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.

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrsZ99VRfWStSYOrBOk%2F-Lrt283efsdRAvaxd61G%2Fview.gif?alt=media\&token=aa2488e8-add0-4a45-ba3b-c9b1a60debbe)

## **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.