With a $schema object, you can ask for $schema->sources and get a list of every registered source. They may not all be tables, but I'm guessing they probably are.

I'm guessing also that you can take the list of sources, instantiate each with $rs = $schema->resultset( $moniker ) and interrogate them for their properties—if you're expecting to find some non-tables in the list.