How to delete a record from a reference table without deleting related records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2021 03:34 PM
I am looking to clean up a reference table. The table holds records of employee names and gives access to the Service Catalog to submit requested items. There are employees listed in it that are no longer with the company that I'd like to delete. I am looking for the ability to delete these records but still have the names show up in the caller and affected user fields in incidents. I located the doc regarding Reference cascade rule (Advanced view) and you are supposed to be able to edit the rule and choose None in the Default field. This is the doc:
https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/data-dictionary-tables/reference/r_DictionaryEntryForm.html
I right clicked on the caller label in an incident and chose configure dictionary, then went to configure form design.
Here is a screenshot of where the properties can be changed:
The employee's name was still removed from the field. I am thinking I am missing a step somewhere. Does anyone have any advice?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2021 04:13 PM
It is used to cascade the delete of child records. For example without cascade when you deleted a REQ it would not delete the RITM or the SC Task records so you would have orphaned records with no parent.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2021 03:59 PM
I am also noticing the the user profile is being deleted when I delete from this table. I suppose the sys_user record is being deleted but I'm not deleting from that table. Here is an example. There was a name in the caller field and now you see the sys_id in the watch list since the record has been deleted.