September 2011
Intermediate to advanced
1008 pages
24h 27m
English
Although you can build your SQL queries by using the tables directly from the CRM SQL Server dataset, doing so is not recommended. The CRM SQL Server tables are shown in Figure 21.50, and you will notice that the Accounts entity has more than one table. The same is true for the other entities.
Figure 21.50 CRM SQL database tables.

Instead of using these tables directly for SQL queries, predefined views make life a lot easier: You don’t have to spend time trying to understand the complexity of the tables by studying an ERD. The views shown in Figure 21.51 will match the CRM entity diagram.
Figure 21.51 CRM SQL database views.