title: Select all Table/View Names with each table Row Count in Teredata
body: <p>I have been stuck into a question.
  The question is I want to get all Table name with their Row Count from Teradata.</p>
  
  <p>I have this query which gives me all View Name from a specific Schema.</p>
  
  <p>I ]    <code>SELECT TableName FROM dbc.tables WHERE tablekind='V' AND databasename='SCHEMA' order by TableName;</code></p>
  
  <p>&amp; I have this query which gives me row count for a specific Table/View in Schema.</p>
  
  <p>II ]    <code>SELECT  COUNT(*) as RowsNum FROM SCHEMA.TABLE_NAME;</code></p>
  
  <p>Now can anyone tell me what to do to get the result from Query I <code>(TableName)</code> and put it into QUERY II <code>(TABLE_NAME)</code>
  You help will be appreciated.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Vrinda</p>