# Column Search Functionality

**URL:** <https://community.dremio.com/t/column-search-functionality/2932>\
**Category:** Uncategorized\
**Created:** [March 8, 2019, 11:37pm UTC](https://community.dremio.com/t/column-search-functionality/2932 "2019-03-08T23:37:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mathew.lee](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mathew.lee/32/1022_2.png) [@mathew.lee](https://community.dremio.com/u/mathew.lee)\
**Post date:** [March 8, 2019, 11:37pm UTC](https://community.dremio.com/t/column-search-functionality/2932/1 "2019-03-08T23:37:11Z")

</div>

Hi Team,

Is there capability in Dremio to search for a column? When joining 2 tables together with many columns (20+), it can be difficult to find the column needed.

If no search function, how about a ‘list’ view of the columns? Instead of having to scroll right to find what is needed, we can just view a list of column headers.

Thanks!  
Mat

---

<div class="post-metadata">

**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\
**Post date:** [March 8, 2019, 11:52pm UTC](https://community.dremio.com/t/column-search-functionality/2932/2 "2019-03-08T23:52:00Z")

</div>

Hi @mathew.lee,

If in the query editor, you can bring up a list of datasets, mouse over a particular one, and then click the “_i_”; this will display a list of columns for the dataset you can drag and drop into your query.

 ![32%20PM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/c/cc43135df08a95084c0f2af455f168cfc4489c0d.png)

Additionally, if you’re a Dremio admin, you can query the metadata catalog:

`SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'your_table'`

This will list the columns for ‘your\_table’ and information about them.

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [March 9, 2019, 5:39pm UTC](https://community.dremio.com/t/column-search-functionality/2932/3 "2019-03-09T17:39:26Z")

</div>

Hi,

If you use the Dremio UI you can use our Custom Join feature that shows the column and allows you to filter them:

![41%20AM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/3a11866e8b88e7196318bc832d195aebf3c08345.png)