you can't. you have to extract the metadata, edit it to change the name &
execute it
then you can do

insert into new_table select * from old_table;

>From: "akalwawork" <work@...>
>Reply-To: firebird-support@yahoogroups.com
>To: firebird-support@yahoogroups.com
>Subject: [firebird-support] How to clone a table
>Date: Thu, 10 Jul 2003 08:52:32 -0000
>
>Hello *
>
>i would like to clone an existing table. The new table should have the
>same structure as an existing table. In MySQL I would execute:
> create table TEST like CUSTOMER
>
>How can I clone a table with Firebird (1.0)?
>
>TIA
>Achim
>
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger