DataGrip 2023.2 Help

Primary keys

A primary key contains unique values and identifies each row in a table.

For some databases, the primary key cannot contain NULL values. A table can have only one primary key, and this primary key can consist of single or multiple columns. When a primary key consists of multiple columns, the data from these columns is used to determine whether a row is unique.

Primary keys can be seen in the Database Explorer. You can see a reference on node and object icons in the Data sources and their elements chapter of Database Explorer topic.

For the table column icons, refer to Possible icon combinations for columns.

Create a primary key

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , expand the data source tree until the nodes of tables.

  2. Right-click the table node and select New | Primary Key.

  3. In the Modify dialog that opens, enter the name of your primary key in the Name field.

  4. Click the Add button (the Add button) in the Columns pane of the primary key editor tab.

  5. In the Column Name field, type or select the column that you want to make a primary key.

  6. In the Preview pane, you can view and change the generated SQL code.

  7. Click OK.

Create a primary key

Create a composite primary key

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , expand the data source tree until the nodes of tables.

  2. Right-click the table node and select New | Primary Key.

  3. In the Modify dialog that opens, enter the name of your composite primary key in the Name field.

  4. Add the columns that you want to make a primary key of:

    1. Click the Add button (the Add button) in the Columns pane of the primary key editor tab.

    2. In the Column Name field, type or select the column that you want to add to the composite primary key.

  5. In the Preview pane, you can view and change the generated SQL code.

  6. Click OK.

Create a composite primary key

Make a column a primary key

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , expand the data source tree until the node of a child table.

  2. Right-click a child table and select Modify Table.

  3. In the Modify dialog that opens, select the column that you want to make a primary key.

  4. Click the click the vertical ellipsis icon (Settings) next to the column Name field and select Make Primary Key.

    The new primary key will appear under the keys node of the tree. The primary key editing tab will appear next to the column editing one.

  5. Click OK.

    Make a column a primary key
Last modified: 22 September 2023
Columns Foreign keys