Query Delete Few Tables Record

[shinyo21]

Hi,

Please, anyone know how to delete few table's record by using one query ?
I want to delete 10 tables, all the records inside at one times. I tried there is only one tables at a time. Is that imposible to do that?




shinyo

 

[GohDiamond]

If all tables are related and referential integrity is established, you can choose to cascade delete all related records. If you delete the TOP-level records, the records in the related tables will be deleted, too, at the same time. Look under the Relationships Menu to see which tables are related. Then double-click on the line representing the relationship to edit it.

I hope this helps,

Goh