Sqlth_te table

Ignition
1

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.

2

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:

select distinct datatype from sqlth_te

Then you need to correlate what datatype they correspond to

3

Yes I mean that.

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

4

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

2 Likes
5

Where can I find documentation for these table definitions?