This is how to Query for all tables/views that contain a particular field name that you're looking for.
This is great for when you're trying to find related fields and don't know what tables to look in.

SELECT sysobjects.name
FROM syscolumns
LEFT JOIN sysobjects ON sysobjects.id = syscolumns.id
WHERE syscolumns.name LIKE '<FieldName>'
ORDER BY sysobjects.name