How to query table column names

[nader.chinichian]

Hello
If I want to get columns from a table how can I do that in ignition with system.db functions?

[mazeyrat]

For mysql

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA=‘yourdatabasename’
AND TABLE_NAME=‘yourtablename’

[nader.chinichian]

@mazeyrat

yourdatabasename

Thanks, what if I want to use SQLite?

[pturmel]

information_schema support is dictated by the SQL standard. Most databases support it, at least partially. Including SQLite.

Let me google that for you.