Featured

Search For Particular Column Across All Tables

Here’s a quick way to search for a certain column name across all your tables in any database.

use master;
set nocount on
select
  table_name
, column_name
from
information_schema.columns
where
column_name like '%documents%' -- replace documents with whatever you're looking for. order by
table_name
, column_name asc
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s