<p>In SQL Server how do you query a database to bring back all the tables that have a field of a specific name?</p>

```
```
SELECT Table_Name
FROM Information_Schema.Columns
WHERE Column_Name = 'YourFieldName'
```
```