How to delete the "u_" on creating a custom table

Nakata1
Tera Contributor

Hi All

Is it possible to create a custom table without "u_" when creating a table?

find_real_file.png

Regard

5 REPLIES 5

Jeff Currier
ServiceNow Employee
ServiceNow Employee

You don't, this is standard behavior and help you keep track of which tables are custom.  Is there a specific reason you cannot use the table with the u_?  Typically end users don't see the table name.

Jillian Hunter2
Kilo Contributor

You can't remove this - it's standard ServiceNow practice which makes it easy to find out which custom tables exist.

Dhananjay Pawar
Kilo Sage

Hi,

This is predefined prefix through this we can easily understand how many tables are custom and how many are OOB.

 

Mark correct/helpful based on impact.

Thanks,

Dhananjay.

chetanb
Tera Guru

You can Re-label but not Re-Name the custom table.

Through background script this could be possible but its bad practice. As there other tables that manage/reference tables.

If you are still in dev environment, then definitely delete and re-create. If you are in production, do the same in dev, but before promoting to production, export the data to XML. If you're brave and talented, you can do a search/replace of the XML file of old table name with new table name and preserve your info. Remember - always test in a non-production instance first!

Have a look -

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/table-administration/task/t_DeleteACustomTable.html