Temp table suggestions don't work if create table statement is removed from editor
Temp table suggestions don't work if create table statement is removed from editor
I've noticed that column suggestions for temp tables only work if I still have the create table statement for the temp table still in the editor, uncommented. Once I remove the create statement, suggestions no longer work; it's like the temp table has disappeared from the metadata despite still being queryable. This is very inconvenient as the only way to get suggestions when writing select statements with a temp table is to keep the create statement in the editor, which requires me to highlight any select statement I want to run. Is this expected behavior?
Re: Temp table suggestions don't work if create table statement is removed from editor
Could you please provide us the full name of the product along with its version?
Re: Temp table suggestions don't work if create table statement is removed from editor
Thank you for the reply.
Such a behavior is by design.
The temp table definition needs to be present in the script in order to be offered in the suggestion list.
Such a behavior is by design.
The temp table definition needs to be present in the script in order to be offered in the suggestion list.
Re: Temp table suggestions don't work if create table statement is removed from editor
Thank you for the response.