I need to delete all the rows in the
ContentData table that have the word 'DV95' in the
Here is what I am using:
BEGIN TRANSACTION DELETE Contentdata FROM Contentlinks INNER JOIN contenttasks ON contentdata.contentid = contenttasks.contentid WHERE contentdata.htmldata LIKE '%DV95%'
Here are my questions:
- Is there problem in the syntax?
- It keeps showing me a number of FK contraint issues due to number of table dependencies. How do I delete these rows?