title: How to get all table and column names from database in Yii Framework
body: <p>I am working on a module where I want to do dynamic dependent dropdown table and column name functionality. </p>
  
  <p>Ex. Fetch all table names and display it in dropdown fields and after selection of particular table I want to display its all column name again in dropdown field.</p>
  
  <p>The issues are:</p>
  
  <p>1) How to fetch all table name from db?</p>
  
  <p>2) and how to fetch all column name from table?</p>
  
  <p>I tried few articles and forums like <a href="http://www.yiiframework.com/forum/index.php/topic/5920-how-can-i-get-the-actual-full-table-name/" rel="nofollow">http://www.yiiframework.com/forum/index.php/topic/5920-how-can-i-get-the-actual-full-table-name/</a>
  but its not working.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Thanks</p>