Forum Discussion

ShivamRelhan's avatar
ShivamRelhan
Copper Contributor
Aug 07, 2025

Unable to get Primary Keys in the tables

I am not able to get primary key in EmailDelivered , EmailOpened , EmailSent , FormSubmitted , FormVisited , WebsiteVisited . 

Below is the reference of one of the Table nad other tables are also present in this :
https://learn.microsoft.com/en-us/common-data-model/schema/core/applicationcommon/foundationcommon/crmcommon/solutions/customerinsightsjourneys/emaildelivered

Could you please help me in finding primary key in these tables. 

Have you ever faced this issue? what should you suggest in this case.

1 Reply

  • ThomasKing's avatar
    ThomasKing
    Iron Contributor

    Many of these tables are external or system tables that do not have a primary key defined in the traditional sense. For example, in the EmailDelivered and similar tables, the combination of fields (like message ID, timestamp, recipient, etc.) often serve as a composite key, but there may not be a single explicit primary key column.

Resources