Deleting Records in sys_user table effecting "sys_trigger" and "cmn_notif_device" and "label_history" tables

[Devi12]

Hi,

In core_company table I have loaded the vendor data manually including "vendor manager" field. Inserting "Vendor managert" field inserted a vendor contacts in "sys_user" table. As I don't want that data I am trying to delete those user records from "sys_user" table. I have written a background script to delete user records from 'sys_user' table. But deleting a record in user table effecting other tables like "sys_trigger" and "cmn_notif_device" and "label_history".

Here I am attaching the screenshot for the same.

Why it is deleting and inserting records from other tables. Can I delete these records.

Thanks in advance!

[Aman Kumar S]

Well you can follow below article to handle deletion of records, well SN doesn;t recommend deletion of users, you can just mark them inactive, if you want to prevent unwanted records to be deleted.

Things to Consider before Removing/Deleting your Data

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂