Difference between Base table and actual table

(0) Share

Report

Posted on by Albert_

452

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.

All responses (4)

Answers (1)

Albert_ 452 on at

Like (1)

Report

RE: Difference between Base table and actual table

Thank you,

I got it.
Albert_ 452 on at

Like (1)

Report

RE: Difference between Base table and actual table

Thank you,

I got it.
Suggested answer

Pedro Cadavez de Fr... on at

Like (1)

Report

RE: Difference between Base table and actual table

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.
Verified answer

Er Prahlad 70 on at

Like (1)

Report

RE: Difference between Base table and actual table

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