Modify

The following topic shows various ways to modify tables in JetBrains Rider.

Modify a table

Starting with JetBrains Rider 2022.1, you can change database-specific parameters of a table. The IDE generates fields for the Modify dialog automatically according to the properties received during the introspection. For example, by using this dialog in PostgreSQL, you can add and edit column check constraints.

In the Database tool window ( View | Tool Windows | Database) , right-click a table and select Modify Table.
In the Modify dialog, specify object settings that you need.
Column settings depend on the database vendor. For example, the Auto Increment checkbox is only available for SQLite, MySQL, and other vendors that allow it for a primary key column of an integer data type.
Click OK.

Inspect same family objects in a table

In the Database tool window ( View | Tool Windows | Database) , right-click a table and select Modify Table.
In the Modify dialog, double-click the family node.

Enable read-only mode for a table

To protect a table from accidental modifications in the data editor, you can make the table read-only.

To enable read-only mode, click the Click to toggle the read-only attribute icon () in the lower-right corner of the editor.

To turn off read-only mode, click the Click to toggle the read-only attribute icon again.

Productivity tips

Modify a table from the data editor

You can modify a table while you edit table data.

Double-click a table to open it in the data editor.
Press Control+F6.
Modify data and click OK.
Press Control+F5 to reload the page.

Last modified: 07 September 2023