Toad World® Forums

Dot Notation with Delete

Doesn’t seem like this works.

If I type

delete table_name t where t.

and wait for the columns to come up, it doesn’t come up. :frowning:

Hi joethejet,

Could you be sure that the table belongs to the current shema? And the SQLNav is 7.3 beta or other version? thanks.

Regards

Alan

Right syntax should be

delete from table_name t where t.

version is 7.3.0.4019

Shouldn’t matter whether it is in the current schema or not. It works either way for select and should for delete too. However, I was in the owner schema.

Torsten, the syntax I used works too. The from is optional it would appear. However, that IS why it isn’t working. If I put From in there, the dot notation works fine.

Hi joethejet,

Thanks for your feedback, we have created a enhancement(SQLNAV-1932) for you.

Besides, as a temporary alternative solution, you might need to replace “DELETE TABLE” with “DELETE FROM TABLE”, and pls let we know if you have any problem, thanks.

Regards

Alan