Sql query
develop...
4
Points
2
Posts
|
Answers
|
Rahul M...
4822
Points
23
Posts
|
If you are not using foreign key constraints , you could do two statements on a single command: DELETE FROM ChildTable; DELETE FROM ParentTable;
But in effect that is two statements. Or You could put a trigger on the ChildTable that deletes parent records on deletion of child record. I think it will help you. If you are trying any query, post query.
Posted On:
16-Feb-2017 22:59
|
Blog
Active User (3)
