Notifications
Announcements
No record found.
I know about filteredview, which embed security, also hold drop-down values and place date in utc format and some other benefits.But I do not know the reason of existing base table for each table.Could you help me on this? or give me a link?For each table in crm we have also a base table that is the same name of normal table with base keyword after that.Best regards.
Hi There,
I found a helpful content for you please checkout the below link:
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/282194/how-many-tables-are-created-database-when-one-entity-creates-in-dynamics-crm?pifragment-97030=1#responses
Thanks
Hello Albert,
Hope you are well.
Taking into account you were able to find the advantages of using the Filtered views, we can consider it a logical extension of the 'Base' table.
When you create an entity it will create both tables, but the Base table is considered the core table. As an example, you can drop a filtered view on SQL directly (unsupported) but you cannot drop simply a Base table. When you drop a filtered view, it will be created again when you make a change on the entity and publish the changes.
Let us know if this provided the required information.
Thank you,
I got it.
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
