DataSpell 2021.3 Help

Modify

The following topic shows various ways to modify tables in DataSpell.

Modify a

  1. In the Database tool window (View | Tool Windows | Database), right-click a and select Modify.

  2. In the Modify Table dialog, specify the settings that you need.

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 (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.

Enable the read-only mode for a table

Show descriptions for databases and tables

  • To enable descriptions for databases and tables, navigate to View | Appearance | Details in Tree View.

    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.

    Show descriptions for databases and tables

Configure GRANT privileges for tables

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

  2. On the Grants tab, click the Add button (the Add button).

  3. In the user field, type the username. You can press Ctrl+Space to use code completion in this field.

  4. 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.

    Configure privileges and roles for user accounts

Productivity tips

Modify a table from the data editor

You can modify a table while you edit table data.

  1. Double-click a table to open it in the data editor.

  2. Press Ctrl+F6.

  3. Modify data and click Execute.

  4. Press Ctrl+F5 to reload the page.

    Modify a table from the data editor
Last modified: 19 March 2022