[Applies to: Microsoft Dynamics CRM 4.0]
To find schema information about any filtered view, entity, or attribute in the Microsoft Dynamics CRM database, use one of the following methods:
- In Microsoft Visual Studio .NET, use Server Explorer to connect to the server where Microsoft Dynamics CRM is installed. Expand the SQL Servers node and the target SQL server instance node. The filtered views can be accessed under the Views node of the <organization>_MSCRM database. Right-clicking the filtered view displays a shortcut menu that enables you to explore the design of the filtered view and the data it returns.
- Log on to an account that has the System Administrator security role. In Microsoft Dynamics CRM, click Settings, click Customization, click Customize Entities, and double-click an entity. Under Details, you can view Attributes and Relationships.
Attributes shows all the attributes that include the display name and a description for each attribute.
1:N Relationships, N:1 Relationships and N:N Relationships show the entities that have a relationship with the current entity, and the attributes that are used to define the relationships. To see the mapping between the attributes, open a relationship form, and, under Details, click Mappings.
- Open the Metadata Browser located at http://<crmserver>/sdk/list.aspx.
- Open the SQL Server Enterprise Manager (SQL Server 2000) or SQL Server Management Studio (SQL Server 2005 and SQL Server 2008) to view the database contents directly.
All the methods that are listed here let you access schema information for custom or customized entities and attributes. For a complete description of Microsoft Dynamics CRM business objects and their attributes, refer to the Microsoft Dynamics CRM SDK Help.
© 2010 Microsoft Corporation. All rights reserved.