• You can also try the following:

    use database_name

    select * from sys.tables where type ='u'

    and name like '%criteria%'