SELECT table_name,table_type,table_schema FROM information_schema.TABLES WHERE table_schema = 'security_domain' AND table_type = 'BASE TABLE';
NOTE:
This sql only query tables under database security_domain
SELECT table_name,table_type,table_schema FROM information_schema.TABLES WHERE table_schema = 'security_domain' AND table_type = 'BASE TABLE';
NOTE:
This sql only query tables under database security_domain