How do I delete a table from the ServiceNow database?

[kevin_eldridge]

I created a table in my ServiceNow instance and need to have it deleted. The table is called Rooms with a name of u_rooms. I tried to re-name the table to Room, but every time I try to rename, the name reverts to label. Is it possible to have this table removed from my ServiceNow database on my instance, ServiceNow ? It is on the Kingston release.

Thank you,

Kevin Eldridge

[kevin_eldridge]

Next time, I will mark it inactive instead of deleting it.

[Shane J]

1. System Definition - Tables
2. Find the table.
3. Hit the Delete button (UI Action), then I think it makes you type in 'delete' to verify

[Shiraz2]

Hi Kevin, when a table is created by a user, the system puts a u_ as a prefix to the name and not to the label. This is for better identification. As for changing the name, you cannot as it is the identifier but you should be able to change the label without any issues. System generated tables have sys as a prefix.

As for Deleting the table, do the following:

System Definitions > Tables > locate your table > Click in that table > click the UI Action Delete > type delete > click ok.

Note:

This option is not available for System Tables.

[kevin_eldridge · Accepted solution]

Hello and thank you both for your information. I should have mentioned I already attempted what you suggested, but it is not alowing me to delete the table. The table is still listed with the name of label and it will not delete from my list of tables. In order to remove it, I had to elevate privaleges. Once I did this it allowed me to remove the table.

Go figure