SQL Assistant Auto Complete documentation

Tools & Utilities
Junior Supporter

SQL Assistant Auto Complete documentation

Is there any document explaining how to use the Auto Complete feature in SQL Assistant 16.20?


Accepted Solutions
Junior Contributor

Re: SQL Assistant Auto Complete documentation

It's described in the Help:

C:\Program Files (x86)\Teradata\Client\16.20\bin\Data

1 ACCEPTED SOLUTION
5 REPLIES
Junior Supporter

Re: SQL Assistant Auto Complete documentation

Also the auto complete is giving function names with first letter Capital, can I have it lower case?

 

Also how can I get UDF to have the same color as system functions?

Junior Contributor

Re: SQL Assistant Auto Complete documentation

Open Options - Code Editor and press F5 :-)

 

You need to modfiy the Language Definition File to change upper/lower/mixed case.

For UDFs you probably need to add them to the file, because the parser doesn't know them.

Junior Supporter

Re: SQL Assistant Auto Complete documentation

Where do I find the Language Definition File in SQL Assistant 16.20

Junior Contributor

Re: SQL Assistant Auto Complete documentation

It's described in the Help:

C:\Program Files (x86)\Teradata\Client\16.20\bin\Data

Junior Supporter

Re: SQL Assistant Auto Complete documentation

Thank You dnoeth, this is what I needed.

 

Do you know how to reset the auto complete for alias? I mean first I write select * from table1 as A then the auto complete for A. with arrow points to table1, but when I write select * from table2 as A then auto complete is still pointing to table1 and not table2. I want it to point to table2.