# Column completion

**URL:** <https://forums.toadworld.com/t/column-completion/9822>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 14, 2010, 9:11am UTC](https://forums.toadworld.com/t/column-completion/9822 "2010-09-14T09:11:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![GrindNerd](https://avatars.discourse-cdn.com/v4/letter/g/8491ac/32.png) [@GrindNerd](https://forums.toadworld.com/u/GrindNerd)\
**Post date:** [September 14, 2010, 9:11am UTC](https://forums.toadworld.com/t/column-completion/9822/1 "2010-09-14T09:11:14Z")

</div>

Hi. I’m running Toad for Oracle 9.7.2.5 and I have a problem with auto completion.

I have a simple statement like this

SELECT \*  
FROM TABLE1 T1, TABLE2 T2  
WHERE  
T1.COLUMN1 = T2.

My problem is the completion after “T2.” doesn’t relate to “TABLE2”. I get a list of columns from another table.

Any clue?

Thanks!

---

<div class="post-metadata">

**Author:** ![GrindNerd](https://avatars.discourse-cdn.com/v4/letter/g/8491ac/32.png) [@GrindNerd](https://forums.toadworld.com/u/GrindNerd)\
**Post date:** [September 14, 2010, 9:17am UTC](https://forums.toadworld.com/t/column-completion/9822/2 "2010-09-14T09:17:55Z")

</div>

I should also add that when I use a different allias for my table, no completion is then available.

And that I tried closing and opening up again Toad, which didn’t do anything to solve my problem.

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [September 14, 2010, 9:17am UTC](https://forums.toadworld.com/t/column-completion/9822/3 "2010-09-14T09:17:55Z")

</div>

Yes – we used to demo this in the toad tips and tricks. The first time you  
use an alias such as T1 it gets stored in a file (I think alias.txt in user  
files). Then that’s the value toad remembers. So you simply need to remove  
it from that file so that it can assume a new meaning ……

---

<div class="post-metadata">

**Author:** ![GrindNerd](https://avatars.discourse-cdn.com/v4/letter/g/8491ac/32.png) [@GrindNerd](https://forums.toadworld.com/u/GrindNerd)\
**Post date:** [September 14, 2010, 9:48am UTC](https://forums.toadworld.com/t/column-completion/9822/4 "2010-09-14T09:48:26Z")

</div>

Thanks for your answer, but I can’t seem to find any file in which my aliases are stored, be it alias.txt or whatsoever in the TOAD folder.

Even then, that would not answer why some new aliases do not trigger any completion.

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [September 14, 2010, 11:34am UTC](https://forums.toadworld.com/t/column-completion/9822/5 "2010-09-14T11:34:13Z")

</div>

Not in the toad install directory – under the windows standard for where  
app files go – on XP it was docs and settings/application data/quest  
software/toad ……

And yes – this exactly describes why you are seeing this problem.  
Let’s say last week you typed the following

Select t2.\* from table\_xxxxxxx t2

Now today you type your command as you listed it – toad remembers the  
table as table\_xxxxx and shows it’s columns. There is online help on this  
and also stuff on [asktoad.com](http://asktoad.com) FAQ

---

<div class="post-metadata">

**Author:** ![GrindNerd](https://avatars.discourse-cdn.com/v4/letter/g/8491ac/32.png) [@GrindNerd](https://forums.toadworld.com/u/GrindNerd)\
**Post date:** [September 14, 2010, 12:08pm UTC](https://forums.toadworld.com/t/column-completion/9822/6 "2010-09-14T12:08:07Z")

</div>

Sorry, I found the file in question. Thanks for the insight!