I therefore propose a feature, to be able to specify in a table schema that a row should be deleted if orphaned.
For one thing, rows can't be orphaned if there's a foreign key reference.
The description was correct even though using probably imprecise terminology. The basic goal is to delete childless parents.
That's kinda what I thought he wrote, but it's so far beyond "normal" that I dismissed the possibility. Parents are allowed to not have children, after all.
Is there ANY DBMS with a built-in reverse FK "parents must have children" feature?
