Find a table by the name in Azure SQL Database

The query below finds tables with a specific name in all the schemas in a database. In this case, it searches for the 'product' table.

Query

select schema_name(t.schema_id) as schema_name,
       t.name as table_name
from sys.tables as t
where t.name = 'product'
order by schema_name,
         table_name;

Columns

  • schema_name - name of the schema where the table was found
  • table_name - name of the table (redundant as it should be exactly the same as provided)

Rows

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

Notes

  1. There might be more tables than one because the different schemas in a database may have tables with the same names

Sample results

0
There are no comments. Click here to write the first comment.