2.10f

0.0(0)
studied byStudied by 0 people
linked notesView linked note
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

5 Terms

1
New cards

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.

2
New cards

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.

3
New cards

Can multiple foreign keys refer to the same table?

Yes, multiple foreign keys may refer to the same table.

4
New cards

What does the FOREIGN KEY keyword indicate in SQL?

It indicates the definition of a foreign key column in a table.

5
New cards

What is referenced by a foreign key?

A foreign key references a primary key column in another table.