Kbase P67059: What is a Foreign Key
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/02/2004 |
|
Status: Unverified
GOAL:
What is a Foreign Key
FIX:
1) A common field shared among tables. It is the primary key in at least one of the tables.
2) The columns in a table whose values must be either null or equal to some value in a corresponding column (called the primary key) in another table. Use the REFERENCES clause in the SQL CREATE TABLE statement to create foreign keys.