On Wed, Jan 22, 2025 at 9:37 AM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Wednesday, January 22, 2025, Ron Johnson <ronljohnso...@gmail.com> > wrote: >> >> >>> 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? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
