New answers tagged sql-query
Thread is 4 years old, and SP is fading away (partly, IMO, because the API is so abstruse and the design so closed), but thought I'd add a response... If you understand the concepts of SharePoint, then it's pretty straightforward to guess what the tables do based on their names... It can be a little more difficult to determine exactly where specific pieces ...
SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too. Also look at the accepted answer in this question . The answer is in PowerShell.
Top 50 recent answers are included