How to delete the "u_" on creating a custom table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 05:38 PM
Hi All
Is it possible to create a custom table without "u_" when creating a table?
Regard

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 05:44 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 06:14 PM
You can't remove this - it's standard ServiceNow practice which makes it easy to find out which custom tables exist.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 08:38 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 09:19 PM
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