Aforeign key constraint can reference columns within the same table. These tables are called as self-referencing tables. For example, consider a table Employee that contains five columns: Employee_ID, Name, Age, Salary and Manager_ID. Because the manager is also an employee, there is a foreign key relationship between the Manager_ID and Employee_ID as shown below:
