Answered

Primary Key Dataverse

(0) Share

Report

Posted on by RobbyG

Hi all,

I want to ask is the primary key / unique field identifier in dataverse is autogenerated by system as guid type and I cannot decide which field/column is the primary key? Because previously I tried to create new table, and then set "Name" as Primary Column, I though that "Name" would be the primary key, but then I try to put the same value when create record, it can inserted. Is anyway I can prevent duplicate "Name"?

Thanks.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Lucas001 2,529 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @RobbyG

the name column is always created once you create a table. This column is also referred to when you chose a lookup column. You can mark the column as optional if you don't want to set it or use it. You can also rename it, but keep in mind the schema name will always be "name".

The primary key of the column is stored in the column "tablename_id". This is the GUID of your row and always specific to that row.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

Was this reply helpful? Yes No
RobbyG 5 on at

Like (0)

Report
Copy link

Link copied!

Hi @Lucas001

Thanks for your explanation. So, the primary key of dataverse always be the GUID field only and I cannot add / change it right?

Was this reply helpful? Yes No
Verified answer

ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey @RobbyG

Unlike other databases, dataverse is cleverly designed to create one-to-many and many-to-many relationships. I.e. As @Lucas001 mentioned Table Guid is unique. The good news is that you want another column to act like a primary key. It is possible with the concept called "Alternate Keys"

Alternate key can be used to uniquely identify a row in Dataverse in place of the primary key.

Official URL for reference

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No