DataGrip 2023.2 Help

Views

A view is a database object that usually represents a database query and can be used as an ordinary table. For more information, refer to your DBMS documentation.

When you double-click a view in the Database Explorer ( View | Tool Windows | Database Explorer), the view is opened in the editor in the Table view. For more information about the views, refer to View data.

Views can be seen in the Database Explorer. You can see a reference on node and object icons in the Data sources and their elements chapter of Database Explorer topic.

Create a view

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , expand the data source tree until the nodes of schemas.

  2. Right-click the schema node and select New | View.

  3. In the Create dialog that opens, enter the name of your view in the Name field.

  4. In the Source Text pane, enter the statement.

  5. In the Preview pane, you can view and change the generated SQL code.

  6. Click OK.

Create a view

Modify a view

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , right-click a view and select Navigation | Go to DDL. Alternatively, press Control+B.

  2. In the DDL editor that opens, make changes to the source code of your view.

    Modify a view using the DDL editor
  3. Click the Submit button (the Submit button). Alternatively, press Command K.

Virtual views

  • If you need to run the same statement and view its result set often, consider using a virtual view which is a DataGrip's virtual object. For more information about virtual views, refer to Virtual views.

    Virtual view
Last modified: 22 September 2023