If you go to Admin mode and try to delete the Block Type I recall it will list the contents it's present on. Inspect the namespace of that ASPX and go hunt using a reflection tool. Maybe you can test that page and catch a SQL call using some Profiler as well.

Thanks for the answer!

I'm a bit new to EPiServer and I think it would work if the blocktype was not from code as in my example.

I can see the remove button for other types but not for my block that is from code.

Will try remove another type in the meanwhile and see if I can't trace the sql.

I know Dejan Caric wrote a blog about that a while back as well if you are looking for some code :)

Check out

http://www.dcaric.com/blog/episerver-9-references-to-content

If you just want the SQL you can always listen to the actual SQL using SQL profiling tools or similar. I would probably have solved it in code but that takes a deploy so...

Ok thanks!

It doesn't look that hard to solve in code so it's probably the right way to go too :)

If you're interesting finding content of a specific content type - how about this SQL Query?

SELECT c.pkID FROM tblContent c INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID WHERE ct.Name = 'NAME-OF-YOUR-CLASS'

You can take c.pkID and add into the url of the episerver edit interface for example www.mydomain.com/episerver/cms/#context=epi.cms.contentdata:///ADD-ID-HERE

Great! thank you!

That helped me achieve what I wanted.

I combined that with the sp editDeletePageCheck and found the references.