Unanswered: Primary and foreign key on the same column
Can both primary and foreign key constraints exist on the single column of a table? E.g. Suppose there is a database DB1 with tables A and B. Now, is it fine to apply a primary key constraint on the column A1 of the table A and foreign key on the same column that references the primary key of table B?