find sql table name with a particular column

Question

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' 

Answer 1

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.