Does SQL Server have an “ALL_TAB_COLUMNS” feature?

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!

Print | posted @ Thursday, July 31, 2008 9:10 AM