Subject | Re: [firebird-support] Duplicate table |
---|---|
Author | leugim@poczta.onet.pl |
Post date | 2006-03-08T22:57:10Z |
Hello!
Is it the only way to duplicat a table?
Regards.,
...michal
Milan Babuskov napisał(a):
Is it the only way to duplicat a table?
Regards.,
...michal
Milan Babuskov napisał(a):
> Boris Herbinière-Sève wrote:
>> I'm trying to duplicate an existing table structure using SQL, but
>> haven't succeeded yet.
>>
>> In Oracle, MySQL, ... you can use a request like "CREATE TABLE
>> duplicateTable AS SELECT * FROM originalTable"
>>
>> Is there a similar trick in Firebird ?
>
> No. You'll have to use some admin too, copy/paste DDL and change the
> table name.
>
>