1.sqlserver
select name as table_name from sys.objects where type='U' and name like '%关键词%'
2.mysql
SELECT distinct TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE '%关键词%'
3.oracle
select table_name from user_tables where table_name like '%关键词%'