Unanswered: Can't create table but name ain't not in sysobjects
I've encountered following problem in a sp in Sybase version 11.9:
Someone had wrote this proc some time ago, using a temporary table #temp_Id to store id's from a table, but the temporary table has never been created ( I thought this might not work... ).
However, I have to make some changes in the proc, and I tried to use the create statement to create that table. I get an error that an object with the same name already exists. I tried a Drop Table command, but then I got the message that the object doesn't exist. A query of the table sysobjects reveals no object with matching name.
Does anyone know how this is possible ?