# Deleting SQL Table

**URL:** <https://forum.inductiveautomation.com/t/deleting-sql-table/84718>\
**Category:** General Discussion\
**Created:** [January 24, 2024, 5:36pm UTC](https://forum.inductiveautomation.com/t/deleting-sql-table/84718 "2024-01-24T17:36:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pico\_Sankari](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\
**Post date:** [January 24, 2024, 5:36pm UTC](https://forum.inductiveautomation.com/t/deleting-sql-table/84718/1 "2024-01-24T17:36:56Z")

</div>

I created a table using a transaction group, but would like to delete it. How can I do this? I tried running 'system.db.runUpdateQuery("DROP TABLE tablename")' from the script console, but this didn't work. Do I need to use a different command to do this?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [January 24, 2024, 7:38pm UTC](https://forum.inductiveautomation.com/t/deleting-sql-table/84718/2 "2024-01-24T19:38:38Z")

</div>

You can run queries in the "database browser" tool. Just make sure the comm is set to "read/write"

note: If something doesn't work, it's usually a good idea to explain what exactly happens. Errors you get, etc.  
It's VERY hard to help if we don't know what's wrong.

---

<div class="post-metadata">

**Author:** ![Alex\_DeBate](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alex_debate/32/56483_2.png) [@Alex\_DeBate](https://forum.inductiveautomation.com/u/Alex_DeBate)\
**Post date:** [January 29, 2024, 4:08pm UTC](https://forum.inductiveautomation.com/t/deleting-sql-table/84718/3 "2024-01-29T16:08:12Z")

</div>

In addition to this, using a tool like [DBeaver](https://dbeaver.io/) as a GUI for the database makes a lot of these tasks easier.
