If you need to search all tables in a SQL Server database to find any tables that have a certain field name, this script comes in really handy.

Run this on the database you are searching...

DECLARE @FieldName varchar(64)
SET @FieldName = 'fieldname' -- Set this to the name of the field you are looking for.

SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%' + @fieldName + '%'
ORDER BY schema_name, table_name;