Link to home
Start Free TrialLog in
Avatar of msimons4
msimons4

asked on

Constraints

If I want to delete rows from a table, can I just disable the constraints, delete the rows, and then enable the constraints or do I have to remove rows from 15 child tables first?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sean Stuber
Sean Stuber

if you have cascading deletes, you might not need to do anything special.

simply delete the parent and the children will update or delete accordingly