title: How to get a list of tables for a specific database when connected using sysmaster user in Informix?
body: <p>Is there a query to get the list of tables and their corresponding max size and size for a specific database when connected with sysmaster user in Informix?</p>
  
  <p>I only can get the size of the given table when I am connected to its corresponding database, but that is not the case. I want to be able to get the table max size and size when I am only connected with sysmaster user. Is there another admin user/database which has such access to all tables information from all databases in Informix?</p>