Find tables with a specific column name in Azure SQL Database

The query below finds all tables that have the 'ProductID' column.

See also tables that don't have a column with specific name.


select schema_name(t.schema_id) as schema_name, as table_name
from sys.tables as t
where t.object_id in 
    (select c.object_id 
      from sys.columns as c
     where = 'ProductID')
order by schema_name,


  • schema_name - schema name of the table found
  • table_name - name of the table found


  • One row: represents a table
  • Scope of rows: all found tables
  • Ordered by: schema name and table name

Sample results

List of tables that have the 'ProductID' column.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.