# How to query table column names

**URL:** <https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549>\
**Category:** Ignition\
**Created:** [December 16, 2020, 6:51am UTC](https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549 "2020-12-16T06:51:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [December 16, 2020, 6:51am UTC](https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549/1 "2020-12-16T06:51:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [December 16, 2020, 7:02am UTC](https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549/2 "2020-12-16T07:02:26Z")

</div>

For mysql

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

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [December 16, 2020, 7:08am UTC](https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549/3 "2020-12-16T07:08:32Z")

</div>

> [@mazeyrat](#):
>
> yourdatabasename

Thanks, what if I want to use SQLite?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 16, 2020, 1:00pm UTC](https://forum.inductiveautomation.com/t/how-to-query-table-column-names/41549/4 "2020-12-16T13:00:55Z")

</div>

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

Let me [google that for you](https://www.google.com/search?channel=fs&client=ubuntu&q=information_schema+sqlite).