# Is there a way to delete a table from internal database

**URL:** <https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 27, 2020, 2:36am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110 "2020-06-27T02:36:52Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhouhcupb](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zhouhcupb/32/16095_2.png) [@zhouhcupb](https://forum.inductiveautomation.com/u/zhouhcupb)\
**Post date:** [June 27, 2020, 2:36am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/1 "2020-06-27T02:36:53Z")

</div>

Hi there.  
Trying to find a way to delete a table from internal database.  
[http://localhost:8088/web/status/sys.internaldb?39](http://localhost:8088/web/status/sys.internaldb?39)

Some one get any idea? 😥

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [June 27, 2020, 3:41am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/2 "2020-06-27T03:41:20Z")

</div>

drop table TABLENAME

Be careful you don’t delete anything important. Make a backup first.

---

<div class="post-metadata">

**Author:** ![zhouhcupb](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zhouhcupb/32/16095_2.png) [@zhouhcupb](https://forum.inductiveautomation.com/u/zhouhcupb)\
**Post date:** [June 27, 2020, 5:21am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/3 "2020-06-27T05:21:00Z")

</div>

Thanks, it works.  
Appreciate your help 👍

---

<div class="post-metadata">

**Author:** ![Jean-Luc\_Stiles](https://avatars.discourse-cdn.com/v4/letter/j/b4bc9f/32.png) [@Jean-Luc\_Stiles](https://forum.inductiveautomation.com/u/Jean-Luc_Stiles)\
**Post date:** [February 26, 2022, 7:15pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/4 "2022-02-26T19:15:49Z")

</div>

I’m going to hope on here, but I am trying this line to clear out some databases I made while doing some module development testing but am getting an error and the tables aren’t getting removed.

“simpleorm.utils.SException$Jdbc: SQL: drop table AAREADERCONFIGURATIONSETTINGS”

---

<div class="post-metadata">

**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Post date:** [February 27, 2022, 3:16am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/5 "2022-02-27T03:16:24Z")

</div>

A simple `DROP TABLE tablename` works in my case.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 27, 2022, 3:45am UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/6 "2022-02-27T03:45:01Z")

</div>

If you are doing this with the web utility, you will have to make sure no trace of the module’s PersistentRecord definitions are hanging around. A complete gateway restart may be necessary to clean up loose ends (with the module already removed).

Also consider shutting the dev gateway down and using sqlite3 outside Ignition.

---

<div class="post-metadata">

**Author:** ![Jean-Luc\_Stiles](https://avatars.discourse-cdn.com/v4/letter/j/b4bc9f/32.png) [@Jean-Luc\_Stiles](https://forum.inductiveautomation.com/u/Jean-Luc_Stiles)\
**Post date:** [February 28, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110/7 "2022-02-28T14:28:51Z")

</div>

Restarting the gateway did the trick. Thanks.