Primary Key length <= 16 #213
christianbraeunlich
started this conversation in
BC Best Practices
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Wanted to create this "Best Practice" a while ago, but I decided against it because the probability of such a case is very low. Well.. as of today, I noticed that there are some cases out there.
The length of the primary key should contain no more than 16 fields, as the SQL Server only uses the first 16 (by its own limitations).
Source: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-keys#primary-keys
Beta Was this translation helpful? Give feedback.
All reactions