answersLogoWhite

0

The foreign key is a reference to a key (identifier) of a row in another or even the same table. When the foreign key is not null, it implies that there's an entry in the referenced table with that identifier.

The syntax depends on wich database are you using, check the page in the related links below.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Types of keys?

There are many keys in database each having particular use. Types of keys in database are : Primary key, candidate key, alternate key, foreign key, surrogate key.


Explain the concept of foreign key How a foreign key differs from a primary key?

Foreign keys are used to link one database with another. A primary key is an attribute of a record that allows users to identify information.


Types of keys in database management system?

super key foreign key candidate key surrogate key unique key alternate key composite key compound key


When a relationship exists between two tables in a database for Microsoft acess what name is given to the matching field in the related table?

The field in a related table that matches a field in another table is called a foreign key. This foreign key establishes the relationship between the two tables in a database.


When checking the database you confirm that the Enforce Foreign Key Constraint property is set to Yes as expected. What property does this constraint create for the database?

The Foreign Key Constraint property creates a relationship between two tables in the database. It enforces referential integrity, ensuring that a foreign key column in one table must have a corresponding primary key value in another table. This helps maintain data consistency and avoid orphaned records.


What is the purpose of cascade delete and cascade update?

When a database has a foreign key "cascade" operations mean operations on the _parent_ will cascade (impact) the _child_ (foreign key reference)


When the primary key of one table is represented in a second table to form a relationship?

This is known as a "foreign key" (the data it points to is foreign to the current record). It is also commonly called a "foreign key constraint", usually in database systems where the database will perform additional data integrity checks when a primary key is updated or removed (such as restricting deletion of the primary record, clearing the value in the foreign key field, or cascading the deletion to the related records).


What is difference between primary key and foreign key?

A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.


What are database constraints?

Constraints put conditions at table level. There are 5 database constraints: 1. unique 2. not null 3. primary key 4. foreign key 5. check


What is difference between foreign key and reference key?

"; '; p[p];p[][p; -; p=p ; ]]p]][ '; ]][ '; ][][.oioiuhkhui uup kk;k;l k;kk;lk; k;; klkp


Which type of database model connects data in different files through the use of a key field?

The relational database model connects data through the use of a key field, which is called a primary key in one table and a foreign key in another table. This key field establishes a relationship between different tables by uniquely identifying records.


What is the foreigh key in DBMS explainwith example?

In the context of relational databases, a foreign key is a referential constraint between two tables.[1] The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. The columns in the referencing table must be the primary key or other candidate key in the referenced table. A table may have multiple foreign keys, and each foreign key can have a different referenced table. Each foreign key is enforced independently by the database system. Therefore, cascading relationships between tables can be established using foreign keys. Improper foreign key/primary key relationships or not enforcing those relationships are often the source of many database and data modeling problems.