# Enabling ignition to see the columns in my database tables

**URL:** <https://forum.inductiveautomation.com/t/enabling-ignition-to-see-the-columns-in-my-database-tables/28570>\
**Category:** Ignition\
**Tags:** database\
**Created:** [September 26, 2019, 9:18am UTC](https://forum.inductiveautomation.com/t/enabling-ignition-to-see-the-columns-in-my-database-tables/28570 "2019-09-26T09:18:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lbuckley](https://avatars.discourse-cdn.com/v4/letter/l/7ba0ec/32.png) [@lbuckley](https://forum.inductiveautomation.com/u/lbuckley)\
**Post date:** [September 26, 2019, 9:18am UTC](https://forum.inductiveautomation.com/t/enabling-ignition-to-see-the-columns-in-my-database-tables/28570/1 "2019-09-26T09:18:19Z")

</div>

Hello,  
I have created a successful database connection for my Ignition project and I can successfully query data by writing SQL queries manually. I am wondering if someone can tell me why I cannot see my DB tables when I try to use DB Browse. Any help would be much appreciated.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/5714bdb747e701533a16d0556f7f956effb92ff5.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 26, 2019, 3:14pm UTC](https://forum.inductiveautomation.com/t/enabling-ignition-to-see-the-columns-in-my-database-tables/28570/2 "2019-09-26T15:14:12Z")

</div>

Check the gateway logs (Gateway Webpage -\> Status -\> Diagnostics -\> Logs) first - see if there’s some error code being reported.

The _most_ likely cause is lack of permissions, followed by some quirk of your DB/connection settings.

---

<div class="post-metadata">

**Author:** ![lbuckley](https://avatars.discourse-cdn.com/v4/letter/l/7ba0ec/32.png) [@lbuckley](https://forum.inductiveautomation.com/u/lbuckley)\
**Post date:** [September 26, 2019, 3:43pm UTC](https://forum.inductiveautomation.com/t/enabling-ignition-to-see-the-columns-in-my-database-tables/28570/3 "2019-09-26T15:43:46Z")

</div>

You were right about it being some quirk of my DB/connection settings. I needed to check the “Include Schema in Table Name” checkbox in the advanced settings area in order to get them to show. Thank you for pointing me in the right direction.