SQL – Server Table Search

Previously I have shared an extremely powerful method of finding objects such as procedures, functions, and triggers…but what about tables (or views)? MS SQL is, once again, able to do this quite easily and logically without the need for any expensive and limited 3rd party software:

USE MyDataBase;
 SELECT
 TABLES.*
 FROM
 information_schema.columns
 JOIN
 information_schema.tables
 ON COLUMNS.TABLE_NAME = TABLES.TABLE_NAME
 WHERE
 (
 column_name LIKE '%SEARCHNEEDLE%'
 )
 AND TABLE_TYPE <> 'VIEW'