How does respawn work with circular references?

[devizer]

/kind Question

How does it work?
Respawn examines the SQL metadata intelligently to build a deterministic order of tables to delete based on foreign key relationships between tables. It navigates these relationships to build a DELETE script starting with the tables with no relationships and moving inwards until all tables are accounted for.

Most of real solutions use circular references.
For example, Employee refers to Department. Department refers to Employee by DepartmentHeadId column.

Example above is natural direct circular reference. There are a lot of solutions use indirect circular references with more than two tables in a circle.

Just deleting is not enough in real life.

How does respawn really work?