Subject Re: [firebird-support] Re: insert into with primary key
Author Martijn Tonies
>> > insert into employee_2008_11 select * from employee_2008
>> >
>> > and employee_2008_11 lost the information of the primary key.
>> What does this mean? Did it lose -metadata- information about
>> which columns are part of the primary key?
> Yes.

But you yourself created table "employee_2008_11", didn't you?
How did you create it?

>> Or do the primary key -values- change when you do the INSERT?
> No. The values are all correct.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: