# Sqlth\_te table

**URL:** <https://forum.inductiveautomation.com/t/sqlth-te-table/7851>\
**Category:** Ignition\
**Created:** [January 16, 2014, 4:16pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851 "2014-01-16T16:16:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![d.laquidain](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@d.laquidain](https://forum.inductiveautomation.com/u/d.laquidain)\
**Post date:** [January 16, 2014, 4:16pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851/1 "2014-01-16T16:16:45Z")

</div>

Hi,

What values can take the column “datatype” in the table “sqlth\_te”?

I want to know, how many boolean, integer, float, string, date tags there are in that table.

regards.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [January 16, 2014, 5:44pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851/2 "2014-01-16T17:44:56Z")

</div>

Are you asking what the datatypes are in the sqlth\_te table? For instance, what 1, 2, 3 equate to?

you could try something like below just to get the different types:

```auto
select distinct datatype from sqlth_te
```

Then you need to correlate what datatype they correspond to

---

<div class="post-metadata">

**Author:** ![d.laquidain](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@d.laquidain](https://forum.inductiveautomation.com/u/d.laquidain)\
**Post date:** [January 16, 2014, 5:52pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851/3 "2014-01-16T17:52:50Z")

</div>

Yes I mean that.

i have just done that query and I have only two values (0 and 1). More information?

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [January 17, 2014, 12:37am UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851/4 "2014-01-17T00:37:14Z")

</div>

0=int, 1=float, 2=string, 3=datetime

---

<div class="post-metadata">

**Author:** ![nskoog](https://avatars.discourse-cdn.com/v4/letter/n/ebca7d/32.png) [@nskoog](https://forum.inductiveautomation.com/u/nskoog)\
**Post date:** [May 15, 2017, 4:06pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-table/7851/5 "2017-05-15T16:06:55Z")

</div>

Where can I find documentation for these table definitions?