Unanswered: How to write a SQL for deleting tables
I am not a very good in SQL but here is my requirement
I have 8 tables for example A,B,.....H.
Now from these tables I need to delete record based on a criteria as date(something like -delete all records from these tables created before 30th march).Now these column has constraints and has to be deleted in the order A,B.....H.
These are the common column in all the tables......Parent ID and Created_date
Can I get some advice on how it can be acheived?I can delete it individually by running a delete statment ,as you all know that is fairly simple.But I have around 6000 rows so its difficult.
Feel free to write back if I need to clarify anything