• You could also use

    sp_tables '%yourcriteria%'