title: show table query in cakephp
body: <p>I need to user show table query in cakephp i have tried manually write <code>SHOW table status FROM DATABASE like 'table_name'</code> but my concern is when i lived this site my database name change accordingly and i do not want to change it manually.</p>
  
  <p>i also tried below code but i could not find my table detail.</p>
  
  <pre><code>$db =& ConnectionManager::getDataSource('default');
  $modelname = "service_requests";
  $query = $db->describe($modelname);</code></pre>
  
  <p>and i expect that my query would return something like below.</p>
  
  <pre><code>[TABLES] => Array
  (
       [Name] => service_requests
       [Engine] => MyISAM
       [Version] => 10
       [Row_format] => Dynamic
       [Rows] => 201
       [Avg_row_length] => 478
       [Data_length] => 96536
       [Max_data_length] => 281474976710655
       [Index_length] => 4096
       [Data_free] => 400
       [Auto_increment] => 202
       [Create_time] => 2012-12-13 17:10:16
       [Update_time] => 2012-12-18 10:27:34
       [Check_time] => 
       [Collation] => utf8_general_ci
       [Checksum] => 
       [Create_options] => 
       [Comment] => 
  )</code></pre>
  
  <p>Thanks you very much.</p>