Nick, I thought this was now supported... i.e. the table is created on the
fly.. or am I only speaking of FB1.5?
Alan

> -----Original Message-----
> From: Nick Upson [mailto:uebridger@...]
> Sent: Thursday, 10 July 2003 6:57 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] How to clone a table
>
>
>
> 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
>
>
>
> 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/
>
>