Yes! 
For those Oracle X.Xers finding themselves working in the SQL Server 2005/2008 world these days, you'll be happy to know all you need to do is:
1. Open up a new execute query window.
2. Type the following:
use FavoriteDbInstance
SELECT
table_name,column_name
FROM
information_schema.columns
WHERE
column_name LIKE '%whateverYouWant%'
That's it!:-) Your table names with the column name you are searching for should show up!