Manually clean up sqlth_te table?

[Felipe_CRM]

I've had to manually excise just portions of data before; wholesale deletion should be relatively easier.

Get familiar with the following schema reference, and probably good to take a backup before you start deleting anything:

Ignition Database Table Reference | Ignition User Manual

EDIT: some interesting considerations in case you plan to also remove the actual data and not just the sqlth_te entries:

History data table clean on tag deletion?

Does anyone have a procedure that they have developed to ‘clean up’ the sqlt_data_ tables if and when history configuration is dropped for a tag? We are going to either stop collecting on a significant number of tags or remove the tags entirely. I would like to remove the history table entries for those tags. We do not ‘prune’ our history per se by date that is to say we are keeping our history indefinitely. An example of an SQL query that takes the old tag name as a parameter and then drops the…