user_tab_columns in sql server?

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!