title: Extract columns from a create statements DDL file
body: <p>How to extract the column names and data types from each table in the below DDL file.</p>
  
  <pre><code>-- Create statement 1
  -- Some text
  
  Create table Test1(
          id int,
          name string
  );
  Create table Test2(
          id int,
          city string
  )
  </code></pre>
  
  <p>Output should look like below for each table -</p>
  
  <pre><code>
  [{"column":"id","dataType":"int"},
  {"column":"name","dataType":"string"}]
  
  [{"column":"id","dataType":"int"},
  {"column":"city","dataType":"string"}]
  </code></pre>