When using the SQL statement CREATE TABLE orders (order_id INT PRIMARY KEY, product_id INT REFERENCES products(id));, what does "REFERENCES products(id)" specify?

Question

Answer

Modifies the "products" table structure

Answer

Deletes the "products" table

Answer

Adds a new table named "products(id)"

Answer

Creates a foreign key constraint on "order_id" referencing "products(id)"

Crowdly

When using the SQL statement CREATE TABLE orders (order_id INT PRIMARY KEY, prod...

Want instant access to all verified answers on my.uopeople.edu?