In Microsoft Dataverse, each table includes a Primary Key (system identifier) and often a Primary Name Column (human-friendly identifier). They serve distinct but complementary purposes.
Primary Key
• A system-generated GUID that uniquely identifies each record.
• Default format is <tablename>Id (e.g., accountid for Account, contactid for Contact).
• Cannot be renamed or changed; ensures data integrity and relationships.
• Used for CRUD operations and to establish links between tables.
Primary Name Column
• A text-based field that provides a user-readable label for records.
• Defaults to <tablename>name, but can vary (e.g., fullname in Contact).
• Can be customized; helps users quickly recognize records in forms, views, and lookups.
• Should be kept meaningful and unique to avoid confusion.
Key Takeaway
The Primary Key secures uniqueness at the system level, while the Primary Name Column improves usability by giving records a clear display name. Both are essential for effective data management in Dataverse.
