i have a problem with the Code Assist in Eclipse and Teradata Studio Express.
select * from db.table where db.table.
select * from db.table as a where a.
Have anybody in idea how to fix that? The settings in Eclipse are OK i think. All options at "Preferences/Data Management/SQL Development/SQL editor/Code assist" are checked. Are there settings on other places that have to be modified?
Best regards Johannes
The code assist doesn't deal with such aliases as your second statement contains. It basically understands what types of database objects (tables, columns, etc.) are valid at the insertion point. It offers choices of names of such objects that are contained in the database object whose name is before the dot.
The editor doesn't maintain the semantic meaning of tokens such as your "a" that are defined only in the context of the SQL statement. It only deals with objects defined within the database. There are no settings to make that will make the editor's code assist deal with aliases.