Subject | Re: [firebird-support] select .. into new_table from exist_table |
---|---|
Author | Ann W. Harrison |
Post date | 2005-06-01T18:49:43Z |
> Ykwings wrote:Nick Upson wrote:
>> Can I use SQL-92 SELECT * INTO NEW_TABLE FROM EXIST_TABLE ???
>
> Only if new_table has identical structure to exist_tableErr, isn't the syntax for that actually:
>
insert into new_table select * from exist_table?
Regards,
Ann