select DISTINCT TABLE_NAME 
  from INFORMATION_SCHEMA.TABLES
 where TABLE_SCHEMA='CCDB'
   and TABLE_TYPE='BASE TABLE'
   and (TABLE_NAME like 'CC%' 
     or TABLE_NAME like 'BO%' 
     or TABLE_NAME like 'CA%'
     or TABLE_NAME like 'SV%')