A primary key formed by combining multiple columns.
An approach where a primary key is formed from a combination of multiple columns, used when a single column can't guarantee uniqueness. It's commonly used in a junction table representing a many-to-many relationship -- for example, uniquely identifying each row of an order-line table by the combination of order ID and product ID.
© 2026 ITBGM