Searching for a specific table name

Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema

 

select *

from INFORMATION_SCHEMA.columns

where table_name like '%t%'

order by column_name

Comments

• Anonymous
  December 29, 2007
  PingBack from http://msdnrss.thecoderblogs.com/2007/12/29/searching-for-a-specific-table-name/