What does Delete Rule = Restricted do?

Posts   
 
    
simmotech
User
Posts: 1024
Joined: 01-Feb-2006
# Posted on: 10-Oct-2017 11:53:40   

I can't seem to find it in the manual (v4.2)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Oct-2017 14:24:23   

It's basically the default when no rule is set: if a PK row is deleted and there's an FK row pointing to that PK row you'll get an error: https://stackoverflow.com/questions/20619211/difference-between-cascade-and-restrict-sql-ddl-database

Frans Bouma | Lead developer LLBLGen Pro