<t>Search Tables:<br/>
<br/>
SELECT c.name AS 'ColumnName'<br/>
,(SCHEMA_NAME(t.schema_id) + '.' + t.name) AS 'TableName'<br/>
FROM sys.columns c<br/>
JOIN sys.tables t ON c.object_id = t.object_id<br/>
WHERE c.name LIKE '%MyName%'<br/>
ORDER BY TableName<br/>
,ColumnName;<br/>
<br/>
```<br/>
<br/>
**Search Tables and Views:**<br/>
<br/>
```<br/>
SELECT COLUMN_NAME AS 'ColumnName'<br/>
,TABLE_NAME AS 'TableName'<br/>
FROM INFORMATION_SCHEMA.COLUMNS<br/>
WHERE COLUMN_NAME LIKE '%MyName%'<br/>
ORDER BY TableName<br/>
,ColumnName;<br/>
<br/>
```</t>
