# Intellisense for CTE's

**URL:** <https://forums.toadworld.com/t/intellisense-for-ctes/58004>\
**Category:** Idea Pond\
**Created:** [August 18, 2023, 8:49pm UTC](https://forums.toadworld.com/t/intellisense-for-ctes/58004 "2023-08-18T20:49:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eli1](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@Eli1](https://forums.toadworld.com/u/Eli1)\
**Post date:** [August 18, 2023, 8:49pm UTC](https://forums.toadworld.com/t/intellisense-for-ctes/58004/1 "2023-08-18T20:49:43Z")

</div>

My co-worker just reminded me of something I've been wanting for a long time: It would be amazing if someone can figure out how to get Data Point intellisense (auto complete column names when typing) to work for common table expressions (CTE's). For example if I write the following:

```auto
WITH MYCTE AS ( SELECT STUFF, THINGS, WIDGETS FROM TABLE)

SELECT MYCTE.
FROM MYCTE

```

It would be great if the auto complete would list MYCTE columns.

Thanks!

---

<div class="post-metadata">

**Author:** ![aaronh](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@aaronh](https://forums.toadworld.com/u/aaronh)\
**Post date:** [November 2, 2023, 5:07pm UTC](https://forums.toadworld.com/t/intellisense-for-ctes/58004/2 "2023-11-02T17:07:53Z")

</div>

This might be a configuration option somewhere? This works for me already.  
Note, I had to use legitimate tables and columns in the CTE for it to work.

Oracle:  
 ![image](https://global.discourse-cdn.com/quest/original/3X/4/6/468e311a35d6cd69da44c71d7646eec389c9b6bf.png)

DB2 for iSeries (ODBC):  
 ![image](https://global.discourse-cdn.com/quest/original/3X/8/c/8c52cf4a131b2b19698870960b5403a3be54618e.png)