Modify
Enable read-only mode for a table
To enable read-only mode, click the Click to toggle the read-only attribute icon (
) in the lower-right corner of the editor.
note
Tables with the read-only status in the data editor can still be modified when using the database consoles or in the Database tool window.
Show descriptions for databases and tables
To enable descriptions for databases and tables, navigate to .
To add comments for tables, select a table and press Ctrl+F6. In the Comment text field, add a table description.
To add comments for a database, open database settings Ctrl+Alt+S and add a database description in the Comment text field.
Configure GRANT privileges for tables
In the Database tool window (), right-click a table and select Modify Table.
On the Grants tab, click the Add button (
).In the user field, type the username. You can press Ctrl+Space to use code completion in this field.
Click the grant field, from the drop-down near each privilege, select Grant or Grant with option. The Grant with option privilege means that a user can grant to or revoke from other users those privileges.
Gif
Productivity tips
Modify a table from the data editor
Double-click a table to open it in the data editor.
Press Ctrl+F6.
Modify data and click Execute.
Press Ctrl+F5 to reload the page.
Gif