Home Forums SQL Server 2005 T-SQL (SS2K5) Delete parent record RE: Delete parent record
Steve Jones - SSC Editor
SSC Guru
Points: 734418
More actions
May 27, 2010 at 8:54 am
#1173371
You'd have to move the child, disable the FK, or drop the FK. My guess is they are moving the child to another record, or a holder record.
Or they don't have FKs defined and are enforcing them in the app only.