Dynamics CRM 2013 – Extension tables removed
By Joe Gill
Published On 18th November 2013
Prior to Dynamics 2013 each entity mapped onto two SQL Server tables. One was the base table and the other was an extension table. The base table contained all the system fields while the extension contained the user defined fields.
In Dynamics 2013 extension tables have been removed and user defined fields are now added to the base table as shown below. This will improve performance as the filtered views no longer need to do a join between the base and extension tables.
