查数据库所有表

sql server

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_CATALOG = 'hjdb';

　　

 

mysql

SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'joinleader_app_run';