Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hello,I have an access to the database of the crm and I have a table.I don't know what entity does that table reference.And I don't know how to find it out.
Google search was useless.
Can you help me ?
Thank you for your query.
You can query EntityAsIfPublsihed view to get Entity name:
--Find by Base Table
WHERE BaseTableName= 'AccountBase'
--Find by Logical Name (logical name= entity view name)
WHERE LogicalName= 'account'
Table 'EntityAsIfPublishedView' doesn't exist
It is not a table, it is a view which is build on Entity object.
You can also query Entity object.
In Dynamics 365 CE, each entity has a SQL table, is created in “YourOrganizationName_MSCRM” database.
The table name for entity is same as entity name (Logical Name/Schema Name. as SQL server is case insensitive) with suffix “Base”.
Also along with SQL table, CRM creates filtered SQL views for entities (except some system entities). Security is embedded in the filtered view.
Hope this help.
Business Applications communities