# Weekly Dynamic: Clear Data Physical Tables

- URL: https://dynamicaccounting.net/weekly-dynamic-clear-data-physical-tables/
- Date: 2012-11-26
- Topics: Tips & Hidden Features, SQL & Data
- Type: original article

There are a few cases where it makes sense to clear data from tables in Dynamics GP. The classic case is when testing something like loading Fixed Assets into a test company. You may need to load, adjust, clear data and reload several times.

When you open Dynamics GP > Maintenance > Clear Data you get a list of logical tables to clear. Logical tables can actually include more than one table. To clear just a specific table, click Display and select Physical. This provides a list of physical tables that you can select to clear.

[![](/img/blogger/9a448a543055e0b4.png)](/img/blogger/70a07f50eba2e8e2.png)