SqlDbx Forum

ptoniolo

Member

drop table with a name that needs to be quoted

I have created a table with a name that needs to be quoted (the last char is a dot). I use it to force the acess to the table via a view with the same name but without the dot. Thus I can control the access to the table via instead-of triggers.

Anyway... the problem is: when I try to drop the table with the sqldbx interface (right click/drop...), apparently the table is removed from the list, but when you refresh that table is still there! I believe that you should always quotename() the name of the dropped object in your internal logic, to be sure to drop the correct one.

Thanks
Pietro

sqldbxhelp

Administrator

Re: drop table with a name that needs to be quoted

Thank you for reporting this issue.
We do correctly quote table name.
The error was in a different place.