How to delete a view? Getting message "Table name xxxx already exists"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-10-2018 05:59 PM
I deleted a view today and I need too recreate it, but when I try to create the view I get a message saying that "table name xxxx already exists" (where xxx is the view table name). I can not find this view in the list view, or in the dictionary; but servicenow thinks it exists. I am at Kingston version. What needs to be cleaned out to allow a new view with the same name to be created?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-10-2018 06:23 PM
hi there,
care to share the screen how you delete the 'view'? and the error screen when trying to create a 'view'?
Assuming you are working on System UI -> Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-10-2018 10:23 PM
Hi jimmillet,
Please refer this link
https://docs.servicenow.com/bundle/london-platform-user-interface/page/administer/navigation-and-ui/task/create-delete-view.html
Please mark it as correct or helpful if it is helpful
Sindhu B
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2018 06:13 AM
It is not UI View...it is Database View. Sorry for causing confusion. Here are the steps:
1. Go to Database View module
2. In list, check the box next to the view I want to delete
3. Select Action > Delete
The delete occurs and I can not find that view in another search in Databasde View list
4. Click New button and try to create view with same name, when I click Save I get the message that "table name xxxx already exists", where xxx is the database view table name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2018 04:16 PM
hi jimmillet,
just tried it in my dev OOTB London instance, I am able to
1. Create a new, delete, and re-create a new Database View.
2. Delete any existing Database View (there will be prompt number of sys_db_view_table been deleted as well), re-create the same view with the same name.
Understand that these Database Views is to join a few tables to be used by Reporting.
Any specific Database View name you are deleting? OOTB Database views? When creating new Database Views, does the 'table name already exists' prompt happen straight away? or is it happen during adding sys_db_view_table related list item?
perhaps u can share some screenshot to be helpful?
cheers.
