>Is there a way in SQL Server Management Studio to find tables with a specific field name?

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME IN ( 
        SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
        WHERE COLUMN_NAME='My Field' 
)