>> > 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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com