Cascade Delete Query

I have three tables. Product, Company, Employee

ProductId of Product table is foregin key for Company and CompanyId of Company table is foregin key for Employee

So on deleting ProductId from Product table, all the related records in other tables should delete. But I can't touch schema(can't use alter table). How should I write the query in that case..

5
задан Nits 27 August 2010 в 10:54
поделиться