Question on references to a custom table you want to delete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2023 06:29 AM
First, I do know how to delete a custom table. This is not about how to delete a custom table.
My question is more around the proper way / best practice way of doing this. Part of the reason we are doing this is because we are moving to out of the box applications. Along with we are high on our custom table count and need to get rid of some old custom tables.
However, many of these custom tables have references in other tables, like Case, Incident, etc.. Along with there are other artifacts attached to these custom tables, such as Business Rules, Workflows, ACLs, etc...
1. When deleting a table, do we need to be concerned about deleting the other artifacts? such as Business Rules, Workflows, ACLs, etc... Are these delete along with the table automatically?
2. What happens to fields that reference records in the table that is being deleted?
Thank you
Marc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2023 07:41 AM
Hey @marclindsay,
I believe that all ACLs, BRs, etc are deleted along with the table. As far as the records go best practice would be to delete the records in the tables prior to deleting the table itself. See the doc link below for more information and some additional points around best practice.
https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/table-administr...
