views:

49

answers:

4

There is a term that identifies a table column that refers to a column in another table. That is the term "foreign key".

Is there a term that identifies a table column that refers to a column in the same table?

An example of such column is the "item_parent" column which refers to the "item_id" column in the following table:
items(item_id, item_parent);

+3  A: 

In docs for SQL Server these references are called "self-references".

Anton Gogolev
+2  A: 

Tables of this type are generally referred to as "self-referencing".

I'm not aware of a specific term for columns involved in a self-referencing foreign key.

Ed Harper
+1  A: 

In addition to "self-referencing", there's the term "reflexive relationship".

For a reference in the MSDN, Click Here

Walter Mitty
A: 

Where did you get the -false- idea that "foreign keys" must necessarily reference other tables (and that there therefore must exist some other term for a foreign key that references the very same table) ?

Erwin Smout
I got that idea from a Wikipedia article called "Foreign Key" - http://en.wikipedia.org/wiki/Foreign_key
Emanuil