find sql table name with a particular column

sql, sql-server

Solution

In SQL Server, you can query `sys.columns`.

Something like:

 SELECT
     t.name
 FROM
     sys.columns c
        inner join
     sys.tables t
        on
           c.object_id = t.object_id
 WHERE
     c.name = 'NameID'

You might want an additional lookup to resolve the schema name, if you have tables in multiple schemas.

Problem

Is their any other way or `sql` query to find the database table names with a particular column than shown below, ``` SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'NameID' ```

Original source

Related problems