Creating a Foreign-Key constraint on Parent/Child Tables
Posted on 2014-09-02
I thought I understood this but apparently I don't. If I want to have a Parent/Child Table relationship and when a row is deleted from the Parent Table and rows are automatically deleted from the Child Table, how do I construct a Foreign Key so that it will facilitate this functionality? I'm using SQL Server 2008 R2.