Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'