# Views

## Overview

This node will show all SQL views from database. If the database has no view the node is hidden.

## Commands Summary

A summary of commands available on a view via right-click context menu:

| Command                                         | Summary                                                                                                    |
| ----------------------------------------------- | ---------------------------------------------------------------------------------------------------------- |
| [Edit table/view](#edit-table-view)             | Opens the [Table Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/table-editor)   |
| [Open SQL Editor](#open-sql-editor)             | Opens the [SQL Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/sql-editor)       |
| [Search for references](#search-for-references) | Searches for where this view is used                                                                       |
| [Create New Form](#create-new-form)             | Opens [New Form Wizard](https://docs.servoy.com/reference/servoy-developer/object-editors/new-form-wizard) |
| [Hide in Developer](#hide-in-developer)         | Flags the table as hidden in Servoy Developer                                                              |

## Commands Details

The details for each command available on this item via right-click context menu:

### Edit table/view

Opens the [Table Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/table-editor) to edit the view and its associated column information (metadata stored by Servoy Developer). The view is handled like a readonly table in Servoy Developer, its structure can only be modified using SQL statements.

### Open SQL Editor

Opens [SQL Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/sql-editor) where you can run SQL queries on the view. SQL Explorer Eclipse plugin needs to be installed in order for this option to show up.

### Search for references

Searches for references of this view (for example forms, relations, valuelists ... that use the view).

### Create New Form

Opens [New Form Wizard](https://docs.servoy.com/reference/servoy-developer/object-editors/new-form-wizard) (using view's datasource).

### Hide in Developer

Marks a view as hidden in developer. This view (and its datasource) will not show up in Servoy Developer wizards and editors.