Notifications
Announcements
No record found.
I have a requirement to extract Dynamics CRM Entities and its attributes using SQL Script from SQL Server Database. Is there any way to do this using SQL Script with SQL Server Database.
Thanks
AR
Hello,
Not sure why you want to do that but you can do that similar to other SQL table depending on which version you are using for example based on the tag it seems you are using CRM 2011, in CRM 2011 there used be two tables for entities,
1. Your entity for example Account
2. Entity+extentionbase for example Accountextentionbase
so depending on your entity name you can look for CRM SQL db and queries these entity to get attributes details.
You can refer : softchief.com/.../
You can extract these details with the help of XrmToolBox plugin Metadata Browser.
carldesouza.com/.../
For SQL Script ->
Go to your organisation_mscrm database->tables->Metadataschema.entity (you will find this at the last)
In this table u will get all the list of entities. Similar Metadataschema.Attribute table for the list of attributes.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 83 Super User 2025 Season 2
Gerardo RenterÃa Ga... 49 Most Valuable Professional
#ManoVerse 40
