title: How to list view tables in DB2
body: <p>I am required to list down all the tables created by view. I know SYSIBM.SYSTABLES will list down all tables, but which field in SYSIBM.SYSTABLES is used to identify that the table is created using view?</p>
  
  <p>Note: I am using DB2 V10.5.</p>
  
  <p>Edit: Reply to @mustaccio, below is the sample of view table.</p>
  
  <pre><code>CREATE OR REPLACE VIEW MYSCHEMA.MYTABLE (
      ...
  ) AS (
      ...
  );
  </code></pre>