JetBrains Rider 2017.2 Help

Databases and SQL

JetBrains Rider features for working with databases and SQL include:

  • Integration with the most popular database management systems such as Oracle, PostgreSQL, MySQL, SQL Server and others. To be able to work with your databases, you should define them as data sources. See Connecting to a database.
  • Database tool window for managing data structures in your databases (View | Tool Windows | Database). See Working with the Database tool window.
  • Database consoles that let you compose and execute SQL statements as well as analyze and modify retrieved data (Ctrl+Shift+F10 in the Database tool window). See Working with database consoles.
  • Data editor that provides a GUI for working with table data (F4 in the Database tool window). See Working with the data editor.
  • SQL code generation and editing features in the database consoles and the editor, e.g.
    • Predefined code snippets (a.k.a. live templates) such as for CREATE TABLE, SELECT, INSERT, UPDATE and other statements (Ctrl+E, L).
    • Auto-completion and highlighting of SQL keywords, and table and column names.
    • Data type prompts for columns (Ctrl+Shift+Space).

    Standardized and DBMS-specific SQL dialects are supported.

  • Structure view for tables in the data editor and Database Console tool window as well as for open database consoles and SQL files (Alt+\). See e.g. .
  • Quick documentation view for database objects and table cells (Ctrl+Shift+F1). See e.g. .
  • Navigation capabilities, e.g.
    • From a table or column reference to its definition: F12.
    • To the view of a table or column in the Database tool window: Alt+F1 | Database View.
    • By means of the navigation bar: Ctrl+F2.
    • By means of the Switcher: Ctrl+Tab.
Last modified: 17 November 2017