did deleting table will be captured in update set??

KM SN
Tera Expert
  1.  If not do we need to delete them in individual instances?
  2. What need to be considered before deleting the table?
  3. Is parent table fields going to be affected if I deleted child table?
  4. Except schema map is there any other feature available in  ServiceNow to track where and where they are using this table? 
1 ACCEPTED SOLUTION

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

This is a very Broad Question but here are my 2 cents on the same

 

  1.  If not do we need to delete them in individual instances?  -> It is captured in the update set, but I would say do it manually.
  2. What need to be considered before deleting the table? --> Deleting all related components before dropping the table.   
    • Client Scripts
    • Ui policies & ui policy actions
    • ACLs
    • BR
    • UI Action
    • Left Nav Menus
    • Reports
    • If this table is parent of any other table
    • Flows/Workflows
    • Integrations
    • If the data in this table falls under Data retention policy of your company then you may need to decide this before dropping the table.
    • ETC
  3. Is parent table fields going to be affected if I deleted child table? -> No
  4. Except schema map is there any other feature available in  ServiceNow to track where and where they are using this table?  -> Schema map will show you where the table is referenced and if any table extends this but it wont show the scripts where this table is used and being called from. So it may still lead to some queries failing.
-Anurag

View solution in original post

9 REPLIES 9

Should be straight forward then. Moreover looks like this is for learning purpose.

-Anurag

learning from a issue/conflict with the help of you people.

 

Abhishek Kathe
Mega Guru
  1. Do we need to delete them in individual instances? No, deleting a table removes all its records in one action.

  2. Considerations before deleting a table: Check for dependencies and back up data.

  3. Impact on parent table fields when deleting a child table: No direct impact, but related records will be deleted.

  4. Other features to track table usage: Application Repository and Metrics Application.

Mate did you just copy my answer and changed some formatting?

-Anurag

Unfortunately, this is going on a lot. People looking to get the numbers of contributions up for some reason by just taking an answer, apply some formatting and pretend to be original. These people should get banned permanently, so they loose the number of contributions all together.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark