# Deleting Test Data from Tables

**URL:** <https://www.five.org/t/deleting-test-data-from-tables/655>\
**Category:** How do I?\
**Created:** [August 12, 2026, 8:43pm UTC](https://www.five.org/t/deleting-test-data-from-tables/655 "2026-08-12T20:43:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)\
**Post date:** [August 12, 2026, 8:43pm UTC](https://www.five.org/t/deleting-test-data-from-tables/655/1 "2026-08-12T20:43:34Z")

</div>

I’m trying to figure out how to clear all of my data from all tables so I can import data from my live Access application.

There are so many foreign key relationships, it keeps telling me I can’t truncate a table where there are live foreign keys pointing to other tables. this seems to be a catch-22. I thought if I deleted all join table data first then it would work, but can’t seem to do this. Is there a quick way to delete all data from all tables?

Is there an easier way to see what records are in a given table other than opening up a new query window and querying the data using SQL?

thanks…