# Create table from SQL data

**URL:** <https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811>\
**Category:** Maker\
**Tags:** perspective\
**Created:** [October 21, 2023, 10:39pm UTC](https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811 "2023-10-21T22:39:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vidar\_Hetlelid](https://avatars.discourse-cdn.com/v4/letter/v/dfb087/32.png) [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\
**Post date:** [October 21, 2023, 10:39pm UTC](https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811/1 "2023-10-21T22:39:10Z")

</div>

Hi there,

Whats the easiest way to create a table in ignition from SQL data?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [October 21, 2023, 10:55pm UTC](https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811/2 "2023-10-21T22:55:36Z")

</div>

1. Write a named query.
2. Drop a table component on the view.
3. Create an SQL binding to your named query on `props.data`.

That gets you going.

1. Then go to `columns` and hit the + icon several times until all your columns show again.
2. Set each column's `field` property to the column name returned by the SQL query.
3. Now select the rendering and format you want for each column using `column.0.render`, etc., and the numberFormat / dateFormat / boolean, etc. to suit the data being displayed.

I'm not familiar with Maker so there may be some limitations.