On Friday, July 7, 2023, Himanshu Upadhyaya <
upadhyaya.himanshu@gmail.com> wrote:
I can think of one scenario, as below
1) any department should have an employee
2)any employee should be assigned to a department
so, the employee table has a FK to the department table, and another check constraint should be added to the department table to ensure there should be one/more employees in this department.
That isn’t a valid/allowed check constraint - it contains a prohibited reference to another table.
David J.