No Assistance in joins within an update

v3.0.24

Assuming this query:

Update tbl
Set Col = 'Value'
From Database.dbo.Table tbl
Inner Join dbo.Table2 tbl2
On tbl2.ID = tbl.

I would expect tbl. to produce a list of columns within Database.dbo.Table. No popup appears after the . and ctrl-space gives list of objects.

That's because of tbl reference in the UPDATE. Clause. SQL Assistant doesn't know if that's a table name or something else. It expects to find a table name there. Because tbl is not a known table, it cannot suggest any columns for this table.

Suggestion, change your SQL to a more common format

Update Database.dbo.Table
Set Col = 'Value'
From Database.dbo.Table tbl
Inner Join dbo.Table2 tbl2
On tbl2.ID = tbl.

this will make SQL Assistant show column list for tbl.