Location of "Sync to Outlook®:" field in database

I need to update the checkbox for many contacts from unchecked to checked.
I want to update this directly in the database dues to the large number of contacts.
What table is the “Sync to Outlook®:” field located in?
Database field name?

Hi hbartel,

the sync to contacts information is an Information related to the user: Each user can select which contacts he/she wishes to synchronize.

The information is therefore stored in the relation table

contacts_users
  • Existence of a record with resp. contact_id and user_id means: sync to contact is selected
  • Non-Existence of such a record, or a set “deleted” flag set means: sync to contact isn’t selected
1 Like

Thank you for the very helpful reply.