title: Display all tables for different schema
body: <p>I have executed this query to show all tables into my db</p>
  
  <pre><code>SELECT TABLE_NAME, num_rows counter 
  FROM all_tables;
  </code></pre>
  
  <p>but the db has got different schema and I want to execute this query for each of these.
  I already tried to select one table for every schema and the only way is from the main schema with this syntax</p>
  
  <pre><code>SELECT *
  FROM X.TABLE
  </code></pre>