Studied by 0 people
Looks like no one added any tags here yet for you.
What is a foreign key in a database context?
A foreign key is a column or group of columns that refers to a primary key in another table.
What must a foreign key clause in a CREATE TABLE statement contain?
The clause must consist of the FOREIGN KEY keyword followed by the foreign key column, and the REFERENCES keyword followed by the referenced table's primary key column.
Can multiple foreign keys refer to the same table?
Yes, multiple foreign keys may refer to the same table.
What does the FOREIGN KEY keyword indicate in SQL?
It indicates the definition of a foreign key column in a table.
What is referenced by a foreign key?
A foreign key references a primary key column in another table.
