Find tables with names with specific prefix in SQL Server database

Query below finds tables which names start with specific prefix, e.g. tables with names starting with 'hr'.

Query

select schema_name(t.schema_id) as schema_name,
       t.name as table_name
from sys.tables t
where t.name like 'hr%'
order by table_name,
         schema_name;

Columns

  • schema_name - name of schema table was found in
  • table_name - name of found table

Rows

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

Sample results

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