Back to articles list
- 1 minutes read
Docs

Tip #6 – How to Create a Multicolumn Primary Key

Vertabelo Team

Primary keys may contain more than one column. Multicolumn primary keys are frequently used for junction tables, which are used to model many-to-many relationships.

Select a table:

Select a table, junction table

In the Table properties panel on the right, check all the columns that you want inside the key:

In the ‘Table properties’ panel, check all the columns you want inside the key, Multicolumn primary key

Now, you have a multicolumn primary key created:

Now, you have your multicolumn primary key created

You can check out your SQL code by clicking the SQL preview button in the top right corner:

Your multicolumn primary key as seen in the SQL code preview

 
 
go to top

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.