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.
