You have cascade delete available on the sys_user table, so as soon as you are going to delete the user table, its associated records will be deleted as well, it is expected behavior.

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

Will be helpful for future visitors looking for similar questions 🙂