<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>

[{'answer_id': 3574, 'author': 'Stu', 'author_id': 414, 'author_profile': 'https://Stackoverflow.com/users/414', 'pm_score': 0, 'selected': False, 'text': "<pre><code>SELECT Table_Name\nFROM Information_Schema.Columns\nWHERE Column_Name = 'YourFieldName'\n</code></pre>\n"}, {'answer_id': 3575, 'author': 'Curt Hagenlocher', 'author_id': 533, 'author_profile': 'https://Stackoverflow.com/users/533', 'pm_score': 0, 'selected': False, 'text': "<p>I'm old-school:</p>\n\n<pre><code>SELECT DISTINCT object_name(id)\nFROM syscolumns\nWHERE name = 'FIELDNAME'\n</code></pre>\n"}, {'answer_id': 3578, 'author': 'GateKiller', 'author_id': 383, 'author_profile': 'https://Stackoverflow.com/users/383', 'pm_score': 4, 'selected': True, 'text': "<p>The following query will bring back a unique list of tables where <code>Column_Name</code> is equal to the column you are looking for:</p>\n\n<pre><code>SELECT Table_Name\nFROM INFORMATION_SCHEMA.COLUMNS\nWHERE Column_Name = 'Desired_Column_Name'\nGROUP BY Table_Name\n</code></pre>\n"}]
['https://Stackoverflow.com/questions/3567', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/230/']