Primary Key vs Foreign Key

EasySQL · PostgreSQL

Problem

What is the difference between a primary key and a foreign key?

Using the provided order table, identify the column serving as the primary key and the column serving as the foreign key. Explain how each key supports data integrity and relationships between tables.

Output

One row per order, with columns order_id and customer_id
Sort by order_id in ascending order

Schema

orders

Column	Type	Description
order_idPK	INT	Unique identifier for each order
customer_id	INT	Identifier of the customer associated with the order, referencing customers.customer_id

Tablesorders

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.