title: How to display all the database tables in a pivot way based on their schemas
body: <p>It's just a question, I don't know how to approach this but is there a simple solution in MSSql query to list down all the tables in a pivoting way based on their schemas.</p>
  
  <p>for example, if there exist 7 tables with 3 schemas</p>
  
  <pre><code>Master.Categories
  Master.Customer
  Transaction.Order
  Transaction.OrderItems
  Catalogue.Product
  Catalogue.ProductPricing
  Logs.OrderLogs
  </code></pre>
  
  <p>...</p>
  
  <p>the output should look like</p>
  
  <pre><code>Master | Transaction | Catalogue | Logs
  Categories | Order | OrderLogs | OrderLogs
  Customer | OrderItems | ProductPricing | NULL
  </code></pre>