Hi Peter, actually the syntax with temporary is ok. However it does not even work with out the temporary statement! Merlin http://www.mysql.com/doc/en/DROP_TABLE.html 6.5.6 DROP TABLE Syntax DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT | CASCADE] "Peter Pistorius" <peterp@podbox.co.za> schrieb im Newsbeitrag 20030417115726.61066.qmail@pb1.pair.com">news:20030417115726.61066.qmail@pb1.pair.com... > DROP TABLE IF EXISTS tbl_name > > Not: > > DROP TEMPORARY TABLE IF EXISTS tbl_name > > Regards, > Peter "Pod" Pistorius > > peterp@podbox.co.za > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php