Skip to Content
Microsoft Dynamics CRM 2011 Unleashed
book

Microsoft Dynamics CRM 2011 Unleashed

by Marc Wolenik, Damian Sinay, Rajya Bhaiya
September 2011
Intermediate to advanced content levelIntermediate to advanced
1008 pages
24h 27m
English
Sams
Content preview from Microsoft Dynamics CRM 2011 Unleashed

Filtered Views

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.

image

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Dynamics CRM 2013 Unleashed

Microsoft Dynamics CRM 2013 Unleashed

Marc Wolenik
Microsoft Dynamics® CRM 2011 Step by Step

Microsoft Dynamics® CRM 2011 Step by Step

Jim Steger Mike Snyder and Brendan Landers

Publisher Resources

ISBN: 9780132682084Purchase book