Deleting a table and recreating it

[yundlu316]

In our team instance, we've deleted a table and tried recreating it with the same exact name, but am running into an error message saying that the table still exists.   The old table is definitely gone so we're a bit confused why we keep receiving that error message.   Any thoughts?

[Tim Owen]

It may help to see the error message.

Also, have you tried clearing the cache?   https://yourinstance.service-now.com/cache.do

More info: Delete a table

[yundlu316]

Hi Tim,

Here's the error I see:

Yes, we've tried clearing the cache as well.   Thanks!

[veena_kvkk88]

I'd think this has something to do with the storage aliases. I know that's true for fields, but I'm not really sure if it applies to table names as well. Check the sys_storage_alias table. Even if you delete a field, if the alias still exists, that might need to be cleared before the field is completely deleted. However, we wouldn't have delete access for aliases, so you might have to contact HI support if that is indeed the case.

[yundlu316]

Hi Veena,

i checked the table and all of the fields in the deleted table still exists there, so I think you may be on to something.   I'm not familiar with HI support, is there a contact number?   When I google HI ServiceNow, it looks like it's more of a SN offering instead of customer support.   Thanks!!