SQL: Tabellen-Struktur ausgeben

#coding
// php
$result = $db->query("SHOW CREATE TABLE tabelle123");
$row = $result->fetch_assoc();
print_r($row['Create Table']);


/* -------- Tabellenstruktur anzeigem
$res = $db->query("SELECT * FROM rezepte LIMIT 1");
$fields = $res->fetch_fields();
foreach ($fields as $f) echo $f->name . "
";
*/