Find tables with names with specific suffix

Query below finds tables which names end with specific sufix, e.g. tables with names ending with 'tab'.

Note that you can also do it in VBA

Query

select MSysObjects.name
from MSysObjects
where
   MSysObjects.type In (1,4,6)
   and MSysObjects.name like '*tab'
order by MSysObjects.name

Columns

  • name - name of found table

Rows

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

Sample results

Query returns names of all tables that ends with "tab"

sample results

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