View source for JDatabaseMySQL/getTableCreate

===Description===
Shows the CREATE TABLE statement that creates the given tables

<span class="editsection" style="font-size:76%;">
	<nowiki>[</nowiki>[[Description:JDatabaseMySQL/getTableCreate|Edit Descripton]]<nowiki>]</nowiki>
</span>

{{Description:JDatabaseMySQL/getTableCreate}}

===Syntax===
<source lang="php">getTableCreate($tables)</source>

 {| class="wikitable"
|-
!Parameter Name
!Default Value
!Description
|-
| $tables
| 
|  A table name or a list of table names 
|}

===Returns===
array A list the create SQL for the tables 

===Defined in===
libraries/joomla/database/database/mysql.php
===Importing===
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>

===Source Body===
<source lang="php">
function getTableCreate( $tables )
{
        settype($tables, 'array'); //force to array
        $result = array();

        foreach ($tables as $tblval) {
                $this->setQuery( 'SHOW CREATE table ' . $this->getEscaped( $tblval ) );
                $rows = $this->loadRowList();
                foreach ($rows as $row) {
                        $result[$tblval] = $row[1];
                }
        }

        return $result;
}
</source>

<span class="editsection" style="font-size:76%;">
	<nowiki>[</nowiki>[[SeeAlso:JDatabaseMySQL/getTableCreate|Edit See Also]]<nowiki>]</nowiki>
</span>
{{SeeAlso:JDatabaseMySQL/getTableCreate}}

===Examples===
<CodeExamplesForm />
<dpl>
 noresultsheader=\n
 category=getTableCreate
 category=JDatabaseMySQL
 category=CodeExample
 category=MethodExample
 include=*
 format= ,,,
</dpl>