Is there an easy way that I can find all of the lists/content types where a particular site column is used?

AFAIK: the only thing you can get is to check whether a column is used by any of the Site Collection content types (SPField.UsedInWebContentTypes Property). If it used however, you would have to manually iterate through all the Content Types yourself.-- http://blog.mastykarz.nl

So, is there no way to do this as a non-programmer? I have a column I want to delete, but I can't seem to find the list or content type where it is used. Thanks!

AFAIK using custom code is the only way-- http://blog.mastykarz.nl

Have you tried this using CQWP or Data Form Web Part?M. Hassan Raza http://mhrhap.spaces.live.com

There is a way, sort of a trick, that might help you.You can use SQL Server Management Studio, and perform a query on the Content Database (usually called WSS_Content_[ID] if you haven't customized it). The query is something like this: selecttp_Title fromAllLists wheretp_Fieldslike'%Title%'Replace the field name (Title in this sample above) with the internal name of the field you're searching for.Field data is stored in an XML string in the tp_Fields column of the AllLists table and, because of that, I cannot assure you that this query returns all the results you need.Note: accessing the SharePoint database is not supported by Microsoft, and it should never be used to update data. This should only be used in exceptional cases where you really need to get that information.

Hassan, can you elaborate a bit on how I would use a CQWP? Andre', this sounds like something I might be able to try. Do you know whetherSQL Server Management Studio is the same asMicrosoft SQL Server Management Studio Express?Thanks!

Hi, I agree with MVP: Waldek Mastykarz, you goal could be achieve by coding. You can also retrieve the data from database provided by Andr Vala Pires, but this is not supported by Microsoft. But I doubt it can be achieved by CQWP, because it can retrieve items with specific content type but not the content types that a specific site column used. For a simple query, you can use Microsoft SQL Server Management Studio Express as well as Microsoft SQL Server Management Studio. Hope the information can be helpful. -lambertLambert Qin | Microsoft Online Support Engineer How to ask a question in the forum (http://support.microsoft.com/kb/555375) Posting is provided "AS IS" with no warranties, and confers no rights.

You can get a list of all sites and lists that use a particular site column through powershell fairly easily. There is a good write up of it found here: http://licomputersource.com/Blog/2010/12/find-what-lists-or-sites-are-using-a-particular-site-column/