delete rows

What is the syntax delete from tablename where ... cascade so I can delete the child records also.
msimons4Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
There isn't a delete cascade.  If the constraints were set up with delete cascade the children are deleted automatically.

If not, delete the children first.
0
 
msimons4Author Commented:
When you truncate a table does it automatically delete the child records or are the child's table FK consstraints disabled?
0
 
slightwv (䄆 Netminder) Commented:
Answered in your new question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.