JetBrains Rider
 
2024.1
Shortcuts: Visual Studio 2022 (Windows)
Get JetBrains Rider
Get your hands on the new features ahead of the release by joining the Early Access Program for Rider 2025.1! Learn more
Upcoming webinar
Uno Platform & Hot Design for Rider
March 11, 2025 at 03:00 PM
  1. Integrated tools
  2. Database Tools and SQL
  3. Database objects
  4. Database tool window
  5. Views

Views

Last modified: 15 May 2024

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 tool window ( View | Tool Windows | Database), the view is opened in the editor in the Table view. For more information about the views, refer to View data.

Views ( View) can be found in the Database tool window. For the reference on other node and object icons, refer to the Data sources and their elements chapter of Database window topic.

Views in Database

Create a view

  1. In the Database tool window ( View | Tool Windows | Database) , 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 to add your view.

Create a view

Modify a view

  1. In the Database tool window ( View | Tool Windows | Database) , right-click a view and select Navigation | Go to DDL. Alternatively, press F12.

  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 .

Virtual views

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

    Virtual view