table-search.sql

SQLSERVER
------------
SELECT 
  TABLE_NAME 
FROM 
  INFORMATION_SCHEMA.TABLES
WHERE 
  TABLE_TYPE = 'BASE TABLE' AND 
  TABLE_NAME LIKE '%TBL%';
 
ORACLE
------------
SELECT 
  TABLE_NAME 
FROM 
  ALL_TABLES 
WHERE 
  TABLE_NAME LIKE '%TBL%';