export table structure

[pelegk2]

uin mysql gui there is a possibility to export a table structure
so if i want to creat another one on another server the same i just copy and run in elswhere.
how can i prin to the screen the table structure but by using a PHP code?
for example

CREATE TABLE /!32300 IF NOT EXISTS/ delivery (
del_id int(6) unsigned NOT NULL auto_increment,
region_id char(3) NOT NULL DEFAULT '' ,
date int(11) unsigned ,
driver_id int(4) unsigned ,
car float ,
weight float ,
closed enum('1','0') NOT NULL DEFAULT '0' ,
round_num tinyint(1) NOT NULL DEFAULT '0' ,
insert_time int(11) unsigned ,
which_place tinyint(1) unsigned ,
tota_money float NOT NULL DEFAULT '0' ,
total_weight float NOT NULL DEFAULT '0' ,
actual_weight float NOT NULL DEFAULT '0' ,
PRIMARY KEY (del_id,region_id,round_num),
UNIQUE del_id (del_id),
INDEX del_id_2 (del_id),
INDEX region_id (region_id)
);

thnaks in advance
peleg

[edcellgavin]

u can do so by
$db = mysql_connect("host", "user", "password");
mysql_select_db("tablename", $db);
$result = mysql_query("show create table table1", $db);
list($table, $structure) = mysql_fetch_row($result);

or using mysqldump which is usually bundled with mysql.
this command in the shell will output the structure of a table to a file

$ mysqldump --add-drop-table -uuser -ppassword DatabaseName TableName > filename.sql

where
-u - database user
-p - db password