If I want to get all the details about the fields in a data entity, for eg. Vendors V2 (details like field type, field length if it's string, etc), whats the best approach?
I can export the table column definition from SSMS on dev server, but is there a better approach?
Data Type, Length and other details of Data Entity Columns
Hi Mohammad,
If it is for a few entities only, you can look at the staging tables for the data types used. You can find type information for the fields in the system table SQLDictionary. You can first find a record with the name of the staging table. Then you know the table ID. Using that table ID, you can find the fields for that table in the same SQLDictionary table.
Data Type, Length and other details of Data Entity Columns
Hello @Andre
Yeah, I wanted to have the column definitions of few entities just once. Dynamics Data Types would be preferred but SQL would suffice if that's not possible.
Data Type, Length and other details of Data Entity Columns
Hi Mohammad,
Do you need to have the column definitions from a few entities just once? Or are you looking for something dynamic to retrieve information depending on e.g. configuration? Do you need the SQL types, or the types used in Dynamics 365 itself? E.g. a F&O enumeration is an integer in SQL. Can you tell more about the purpose and what you will do with the information once you have the column definition?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.