Where do custom entities get stored in the Microsoft CRM database?

When you create a custom entity in Microsoft CRM, Microsoft CRM creates 2 tables in the SQL Server database for each custom entity. The names of the tables will match the name of your custom entity, so the tables are typically not hard to find in SQL Server.

You can also run this query against your CRM company database to see the database tables for your custom entities:

select * from EntityView where LEFT(name,4)='new_'