Notes on Querying Entities

I'm sure most developers when they first get their hands on Dynamics look at this thing and think, well great, but how do I know what tables related to which 'entities'. I know I did. Well, further to my previous post regarding table names, open a new browser window and try this :

http://<CRMServerName>/sdk/list.aspx

Or

http://<CRMServerName>/mdbrowser/entity.aspx?entity=<entityName>

So, there you have it. A list of all entities within your deployment, their definitions and associations. What is even more, each entity listed is in fact the name of the relevant table minus the word 'base'. So, if you take any entity, add the word 'base' and look it up in the SQL Server Management studio, you will be able to see the relationships for yourself.