<p>I have a large database and would like to select table names that have a certain column name. I have done something like this in MySQL, but can't find any info on SQL Server.</p>

<p>I want to do something like:</p>

<pre><code>select [table] 
from [db] 
where table [has column 'classtypeid']
</code></pre>

<p>How can I do something like this?</p>

Use the ANSI information_schema views, this will also work in MySQL
```
```
select table_name 
from information_schema.columns 
where column_name = 'classtypeid'
```
```