Notifications
Announcements
No record found.
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 ?
Thanks.
Hi,
Thank you for your query.
You can query EntityAsIfPublsihed view to get Entity name:
--Find by Base Table SELECT [Name] EntityName, ObjectTypeCode, BaseTableName FROM EntityAsIfPublishedView WHERE BaseTableName= 'AccountBase' --Find by Logical Name (logical name= entity view name) SELECT [Name] EntityName, ObjectTypeCode, BaseTableName FROM EntityAsIfPublishedView 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”.
Example -
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.
Thanks!
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 170 Super User 2025 Season 2
#ManoVerse 61
Gerardo Rentería Ga... 52 Most Valuable Professional
