# How to remove a variable from the database

**URL:** <https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [February 2, 2022, 5:32pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671 "2022-02-02T17:32:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![patricio.rojas.bolom](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@patricio.rojas.bolom](https://forum.inductiveautomation.com/u/patricio.rojas.bolom)\
**Post date:** [February 2, 2022, 5:32pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671/1 "2022-02-02T17:32:17Z")

</div>

I had a variable which history, this variable was removed from the history and the variable was removed.  
The problem is that I don’t know how to delete it from the database (only that variable). The reason is that it keeps appearing in “POWERCHART”

 ![02 - copia](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/4/84091cf43c145bcb966389259769436da073b2e8.jpeg)

Is there any ignition program that can see all the variables in the database and delete just one without the database getting corrupted?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 2, 2022, 5:35pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671/2 "2022-02-02T17:35:52Z")

</div>

Delete the corresponding entries (there may be multiple) from `sqlth_te`. Make sure you match up the IDs if you have multiple gateways connected to the same database.

If you’re not comfortable with that, I would recommend getting in contact with support.

---

<div class="post-metadata">

**Author:** ![patricio.rojas.bolom](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@patricio.rojas.bolom](https://forum.inductiveautomation.com/u/patricio.rojas.bolom)\
**Post date:** [February 2, 2022, 5:47pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671/3 "2022-02-02T17:47:26Z")

</div>

Dear, I’m new to this and I don’t understand how to do it, do you have a graphic help?

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [February 2, 2022, 6:11pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671/4 "2022-02-02T18:11:25Z")

</div>

Something like this, though may differ depending on what database you are using. You want to be sure you have the right tag ID as PGriffith mentioned. My screen shot is through MS Server Management Studio, though you could run the query through ignition aswell.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/0/f0b2e7cd493ba435989f94901764438e785366f6.png)