In order to delete product category translations please go to Products > Categories.
Here set the language filter for the language content in which you would like to delete the categories. You can also use the top admin bar language switcher for this purpose.
because we found that in UAT, if we delete it one by one, please find the attached picture of the problem. So we would like to remove it from database. So which field of content we can sort out and remove?
I am a programmer, you just let me know which field of content I can sort out the product category translation in simplified Chinese in the database. I will then handle the left by myself and I will bare the responsibility for any disaster damages. Thanks.
Then you would further need to check for the table icl_translations which connects those terms between languages, but you need to know the ID of the category that you would like to delete. It would be on the table the same as the element_id on this table.